Can't get exclusive access

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I just set up user-level security on a database that I
plant to use over a LAN.

All I did was set up three users in three different groups
to test this out. I logged in and out with the users and
everything seemed to be working as I expected.

However, now I'm trying to make some design changes to a
form, via a username that does have the access to do it,
and it keeps telling me that I don't have exclusive access
and can't make the changes.

I looked through the help files and tried opening the
database as exclusive, but I still can't get in. What am
I doing wrong, how do I fix this?
 
Starting with 2000, you need exclusive access to make design changes. How
are you opening exclusively?

Open Access; use File, Open and locate your mdb, click on the 'Open
Exclusive' in the dropdown in the lower right.

Or if you are using a desktop shortcut to open the database, add /excl to
the end.

If that isn't working, are you sure that the username you are using has
'Open Exclusive' permission on the database object?
 
Thanks so much.
adding the /excl worked perfectly.
I spent about 3 hours yesterday banging my head against
the wall on this one, I REALLY appreciate your help.
 
Back
Top