Hi.
I have an Access 2010 database that is splitted into one frontend and one backend file. The frontend is saved as an .accde file, both files are stored in a shared network folder.
When I myself opens the database, everything is OK, but when someone else opens the same file, they just get the message
"The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code from modules, forms and reports. You should back up your database before attempting to open the database and delete the VBA project."
Clicking Cancel does not help. It just pops up again. The user HAVE to click OK and by doing so, all VBA code is lost.
Why does this happen? Why is it OK when I run it? Could it be something with user rights both for the frontend and backend file? (seems odd that the code is deleted though, since this action would change the frontend file). Could it be that I have enabled some advanced feature within Access while creating the database, that other users have not enabled?
Anyone who have any idea?