I have a database that has had a lot of corruption errors lately (like 1 or 2 a week) and I've been told that splitting the database can help with this (even if it doesn't resolve it). Ultimately I am going to convert the backend to SQL, but don't have the access rights yet to do that. So in the meantime, I just need a little help. What is the difference between creating an MDE file and splitting a database? Is there a preference? A benefit in one over the other? I just want to make sure that I make the right choice! Any help from the experts would be greatly appreciated!
Thanks in advance!
Thanks in advance!