Hello everyone. I am hoping that someone has a simple answer to this problem. I have an Access 2002 front end to an Oracle database. The tables are linked into Access and we use ODBC to connect to Oracle. The .mde file is located on 3 shared drives and potentially accessed by hundreds of users. The problem is that some of the users have been upgraded to Microsoft 2003 and they now receive an error when they try to open the application - You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later. They have to click on OK dozens of times to clear the error and they are never able to use the file. Everything I have read says that you can no longer make design changes in a shared mode, but this is an .mde file and users are only entering data, no one is permitted to make design changes. The file name for the application is cms.mde and the locking database is cms.ldb, they are both in the same location. Can this be the problem? If so, what can I do to fix it?
Any help is appreciated.