How do I get past this error: "It is already opened exclusively by another user, or you need permission..."?

Troy Wolbrink — Fri, 16 Jan 2009 17:51:26 GMT

Current revision posted to Frequently Asked Questions by Troy Wolbrink on 1/16/2009 5:51:26 PM

How do I get past this error: "It is already opened exclusively by another user, or you need permission..."?

Filed under: Troubleshooting

If you are trying to open a TntMPD database on a network share or network drive and if you receive this error message:

The Microsoft Jet database engine cannot open the file '\\SharedComputer\My Documents\Something.mpddb'. It is already opened exclusively by another user, or you need permission to view its data.

Here's one possible solution that seems to work most of the time:

From the host computer:
1. Open the folder where this TntMPD database exists.
2. Select the database ("Gerry.mpddbSomething.mpddb").
3. Under the "Edit" menu, click on "Copy".
4. Under the "Edit" menu, click on "Paste".
(You should now have an additional file "Copy of Something.mpddb".)
5. Delete the original database file ("Something.mpddb").
6. Rename the "Copy of Something.mpddb" to "Something.mpddb" (remove "Copy Of" from the name).

That's it! This little trick seems to take care of the problem most of the time. Hopefully it works for you!