I have a client who opens an access 2010 database fine and can select any data within the database ok. When he goes to close the file he gets and error message:
Could not use 'C:\Users\username\Documents\Pmaster\databasename. mdb'; file already in use.
I have compacted and repaired the database and when I open and close the database on a different machine there is no problem.