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.
Access 2003 is more forgiving for haring an mde but there were still issues.
Access 2007 and later do not like to share a front end .accde which o helps eliminate issues. Each user will need their own copy of the front end .accde. No way around it with Access 2007 or later.
In your case, to keep the IT people happy, I place an app launcher .accde on the server. The launcher will copy the front end to the local workstation and then launch it.
Are you creating a trusted location for the .accde on each workstation?
Boyd Trimmell, Microsoft Access MVP