Display of Message "You do not have eclusive access toa database..

[Guest]

Hi Can someone please help me??

Whenever there is more than one person logged into a networked database we
get an icon that says we do not have exclusive excess to the database. if we
click the "OK" button 31 times the icon disappears and everythink apears OK.
If only one user is using the database we do not get this message

Can anyone please help me??

 

[Lynn Trapp]

The first thing to check is to see if all users have full access to the
folder that the database resides in. Particularly make sure they have both
write and delete permissions to the folder.

--
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]

Yes Lynn I think so ( not that I have checked) as if only one person is
logged onto the database we don't get this annoying icon message so I'm
assuming that we do. I shall check this when I go back to work for sure, but
I would think so??

The second someone else enters the database the subsequent new users always
get the icon displayed requiring the new user to press enter 31 times.

I would think if many one users can enter and delete information from the
database, then the permissions would be set correctly wouldn't they??

 

[Joan Wild]

If you want to double check that users have the correct Windows permissions
on the folder, then have one of them open the folder in Windows Explorer.

Right-click, choose new..text file, and create a text file and save it - if
they can then they can't, then they don't have create permissions on the
folder.

If they can, can they then successfully delete this file? If they can't,
then they don't have delete permissions on the folder.

 

[Guest]

Yes Joan, I had a few people check there read, write and delete capabilities
and everyone is able to write, edit, delete capabilities in the foder that
has the database.

Where do I go from here??

Please help, any advice will be well received.

Many thanks,
Ian

 

[Joan Wild]

What is the exact text of the message? What does it say on the title bar of
the message box?

The '31' times seems odd. Perhaps there is code in a startup form that is
triggering this?

 

[Guest]

Hi Joan,

The exact message is "You do not have exclusive access to the database at
this time. If you proceed to make changes, you may not be able to save them
later."

Help us please !!

 

[Joan Wild]

Check the properties of the mdb - Tools, Options, Advanced tab - default
open mode.

If users are using a desktop shortcut to open the mdb, check that the
shortcut doesn't have a /excl switch in the target.

You should split the database and have just the backend (tables on the
server). Give each user a copy of the frontend (all other objects) on their
workstation. The frontend would contain linked tables (linked to the tables
in the backend on the server).

Also (just to be sure), this is happening on opening the mdb? Or is it when
they enter design view?

 

[Guest]

I have exactly the same problem. I have a shared MDE file that most users
have no problem with. Then, occasionally, one of the users will have to
click OK 31 times to the "you do not have exclusive access..." message to log
into the database. I have not been able to resolve the problem. Usually, if
I uninstall Access and manually clean up the registry, then reinstall, the
message will go away.

 

[Guest]

I am having exactly the same problem. THIRTY ONE TIMES. Of the eight
databases that I converted only one is having the problem. Why Microsoft?

 

[Guest]

I am also having the issue with some users not everyone, it seems to be
machione specific.

 

[Guest]

If the database is on the server then the user's machine has no impact on the
problem.

The solution is really quite painless. Create a new empty Access database
and import all of the old databases objects into it including if you use them
import/export specifications (see options on import).

You can then set your password, startup, etc on the new database and you are
good to go.

This is a far better solution then trying to get Microsoft to resolve the
issue.

 

[Guest]

ok, we found out what is causing the problem at our workplace. Only users of
Acrobat professional 7.0 are getting this error message, because in the
install routine, there is an option to load Adobe PDF MAker into Office
Products (including Access). We had to go into the add/remove programs for
Adobe, click Modify->create Adobe PDF, expand to Acrobat PDF Maker and Expand
to find Access and deselect the add-in for Access. Apparently this is
considered a design change when trying to load this PDF Maker into Access and
it requires exclusive access.

 

[Joan Wild]

Wow. What an obscure one. Thanks for posting back with the resolution!