MS Access 'already opened exclusively' error

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?

.

Relevant Pages

  • Re: Problem logging users off to make changes
    ... > I have a database that I can't change unless I personally go to 150 ... > machines and log the users off. ... Email requests for all users to log ... The form that tells them to close the app has a timer with a 5 minute ...
    (microsoft.public.access.security)
  • Re: Import Choice Data into Access From Excel
    ... The security that we are putting in place for this database is having ... data elements are the same for all machines, then add a field that identifies ... put into a different mdb with _be added to the name. ...
    (microsoft.public.access.externaldata)
  • Re: Cant be started. Was unable to initialize the Windows Registry. Rerun Microsoft Access or Micros
    ... running on machines all over the LAN. ... I ran the app as domain admin and local admin, ... At least I know the mdb is not corrupted. ... There might be a problem with the file type relationships on that machine oder ...
    (comp.databases.ms-access)
  • Re: Request for suggestions re: architecture of IntraNet/Socket app[s]
    ... I am commissioned with determining the "right" architecture for an application for controlling movement of stock in a warehouse. ... Much of your system describes monitoring -- control implies schedule and tracking for purposes of changing system operation -- correct? ... If multiple machines can handle the pieces and some machines do different operations -- then there is an element of scheduling and a time frame in which to complete. ... separate RealTime system either from the IntraNet server app OR from another ...
    (borland.public.delphi.non-technical)
  • Re: access runtime version
    ... that they needed to have access on each of the machines that were going to ... run the database - and this they agreed to. ... leave it as a mdb as there are poeple in the organisation (who do have ... > While the Developer Edition doesn't alter the mdb in any way, ...
    (microsoft.public.access.gettingstarted)