Microsoft Jet Database error

[adamb]

I have a user that receives the following message when attempting to open a particular EA file:

An Error has occurred: The Microsoft Jet database engine cannot open the file \\path . It is already opened exclusivley by another user, or you need permission to view its data.

I have already searched the forum. I copied the file to the local system to remove the Read Only status. This condition did not exist. I set the use Jet 4 box. Once I changed this the user can open the file on their system but not on the network share. I have attempted a repair, however, the system responds that the action cannot be performed on the object type. Also, I cannot gain access toeh Manage .EAP file | Repair .EAP file option without having a project open.

What steps do I take next?

[thomaskilian]

Can you open the file using simple tools like MSQRY (concurrently from different locations)?

[adamb]

Exactly how do I accomplish the MSQRY?

[Bruno.Cossi]

Do you have MS Access installed on your computer? Try to open the .EAP file using MS Access (the .EAP file is just an MS Access database with the extension changed).

Bruno

[thomaskilian]

MSQRY comes with MS Office (look near "C:\Programme\Microsoft Office\Office\MSQRY32.EXE" (german path settings). You also need to establish an ODBC connection to your database. MS Access driver is the right one. Now you can start MSQRY32 and pass the ODBC source. You should be able to see the tables and their contents.

[Jacques_Ronaldi]

Your database file is opened. Reboot the computer and try again.

If that doesn't help, then the Access lock file has been left dangling: using Windows explorer, go to the location of your EA file. It has a .EAP extension.

Delete the file that has the same name but which has a .LDB extention. This is the Access lock file causing you problems. If you can't delete the lock file, then a program *IS* using the database...