Read some info online and it sounds like something I should do to speed up my database however, if the database is split with a frontend and backend, which one do I apply the compact and repair to?
Also is there anything that I need to worry about when doing this process? Like compatibility issues with different versions of MS Office or other things? Of course I will make a backup before I start.