Posted on 2013-11-13
I just upgraded my 2003 database to Access 2010. I was using a .mde file on a Novell-Delivered Application window for users to access the database. I updated to .accde and pushed that out.
Now I am having extreme issues. People can get in, but then it freezes. They try to go back in and get '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 the modules, forms and reports. You should back up your database before attempting to open the database and delete the VBA project....." Or that the file is unstable.
I can copy over the original .accde file to the share point and it's works for awhile but once again after you get a few users in it, it locks up and does this again.
I can put the .accde on the user's desktops and it works fine but our IT department is not really liking that as an option, they want it to work from the Novell-delivered Application window.
Any ideas as to why this is failing where the .mde file was fine?
Help would be appreciated.