I have Access 2010 and want to compact and repair the database.
I get this error message (this is translated, so it is not the exact words):
“Cannont compact and repair the database. You may not have permission to the folder where the database reside. You must have full permission to the database folder to be able to compact and repair the database. Contact the system administrator for more information.”
The only information I have found on this matter is for Access 2003, and it was related to user permissions in the database. And in Access 2010 there is no user permissions anymore.
Is the problem related to permissions on the server (the database file is located on a server (not Sharepoint)). Since the user can open the database I guess she have permission to create files (the .laccdb-file is created when the database is opened).
I am lost here. Can anyone help me?