You do not have exclusive access to the database at this time.

  • Thread starter Thread starter p sqrd
  • Start date Start date
P

p sqrd

I support an Access application that is rolled out to approximately
1000 users. The frontend and security file are pushed to a folder on
their hard drive and the backend is maintained on a network server. Of
the 1000 users only three are getting the error message, "You do not
have exclusive access to the database at this time....." The
explanation given on Microsofts knowledgebase does not accurately
describe my situation. The .mdw file and the frontend .mde file are
not named the same so they could not have conflicting .ldb files.
Since this application is pushed via a zenworks package to the user
community, the problem machines should have the same setup as all other
machines.

When these three people open the application, they get the above error
message over and over again about 10 times and then are finally able to
use the application. There are several macros and procedures that are
fired off when the application opens so I am sure that whenever a new
call is made the error message is displayed, the user responds and the
application goes to the next call. Once thru the calls, the main form
for the application is displayed.

Any suggestions on what is happening here or similar situations?
 
p sqrd said:
I support an Access application that is rolled out to approximately
1000 users. The frontend and security file are pushed to a folder on
their hard drive and the backend is maintained on a network server.
Click to expand...

Have you tried having a single mdw file next to the BE on the server?

Keith.
www.keithwilby.com
 
I have been getting this same message for the past few months and have
verified the file rights but with no luck. It seems to be getting worse. At
first it would give the "exclusive..." message about 2 or 3 times. Now it is
up to around 30 times. I have other mdbs in the same folder and they do not
give this message. The mdb is about 55 mbytes and has linked tables to
SQLServer and is on a Novell network. I have also tried placing the mdb on a
local pc and get the same message when I map to that pc.

I have noticed that when I open Access first then select the mdb, this
message does not appear.
 
Back
Top