Re: MS Access 'already opened exclusively' error

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On 13 Dec 2006 08:37:25 -0800, "Jared" <google@xxxxxxxxxxxxxxxxxxxxxx> wrote:

I have three machines running the same C# app, all accessing the same
MDB file, which is shared on one of the machines. All machines have
the same version of MDAC (2.8). The database does not use Access
multi-user security, but is password-protected. Each machine connects
to the database on a regular basis (i.e. about once each minute on
average), and performs more reads than writes. The app is written in
such a way that all connections are closed properly, and I'm using JRO
to compact/repair the MDB daily.

I occasionally get the following error message: "You attempted to open
a database that is already opened exclusively by user 'Admin' on
machine '(machine name)'. Try again when the database is available."

I've been logging these errors, along with the calling method
information. The errors are not associated with a single method, and
do not seem to be caused by any specific thing that my app is doing.

I've heard people complain that Access is buggy, but I've used it a lot
over the years with much more demanding apps and never had this kind of
problem. I had originally considered using MSDE, but decided on Access
because a file-based database is easier to apply structure changes to
(i.e. make a copy, update original via DDL, replace with the copy to
rollback if necessary) and is easier to back up (i.e. just FTP the MDB
file to a remote site). MSDE is also more problematic to install on a
target machine.

Since I'm not using MS Access to open the file, this error appears to
be incorrect. Does anyone have any experience finding the true source
of this error, or with troubleshooting problems with Access in general?

This is a shot in the dark...

Do you have the database password protected?

If you don't, you may have a user who is opening it with Access and using it in
a way that would cause locking.

Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com
.

Relevant Pages

  • (no subject)
    ... - LDB locking which a persistent recordset connection fixes ... New format of Access 2000 MDB ... Place backend MDB on the root of the network share rather than several folders down ... Subdatasheets are a new feature in Access 2000 Therefore, you are more likely to notice this behaviour after you convert a database from an earlier version. ...
    (comp.databases.ms-access)
  • Re: Editing fields in a linked table
    ... Then in the user app, ... Dave Hargis, Microsoft Access MVP ... have to make the change in the database file (mdb, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Editing fields in a linked table
    ... Then in the user app, ... Dave Hargis, Microsoft Access MVP ... you cannot do it easily from the front end database. ... have to make the change in the database file (mdb, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: temp db
    ... If the database is not in use, you can create a copy just by copying the MDB ... The purpose is to create a temp db for all the ... ' This subroutine illustrates how to use a temporary MDB in your app. ...
    (microsoft.public.access.formscoding)
  • RE: Access to Access Automatic Updates
    ... Then navigate to the database from the File Open dialog and open it. ... You will need to do it for mdb that has tables you need ... MS Office Master 2000 ed. ... you will need to create a form that opens on ...
    (microsoft.public.access.externaldata)