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

[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?

 

[Lynn Trapp]

What permissions do these 3 users have to the folder where the backend
database resides?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[p sqrd]

They have read/write access just as everybody else does.

 

[p sqrd]

I had the Lan people check their access to be sure they were set up
like everybody else.

 

[Keith Wilby]

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.

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

Keith.
www.keithwilby.com

 

[Lynn Trapp]

Does everyone also have Delete permissions?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

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.