Adding another Administrator

  • Thread starter Charles L. Phillips
  • Start date
C

Charles L. Phillips

I have access to an MS-Access 97/2003 database, that is being shared on the
network. When I try to make changes, I get the following message:

"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."

I make sure every User who has access to the database is shut down, so no
one is accessing the database, at the time I need to make changes. I need to
add 2 additional Users as Administrators & make some changes to the database.

Can/will someone help me with this issue???

Thank you,
 
J

John Vinson

I have access to an MS-Access 97/2003 database, that is being shared on the
network. When I try to make changes, I get the following message:

"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."

I make sure every User who has access to the database is shut down, so no
one is accessing the database, at the time I need to make changes. I need to
add 2 additional Users as Administrators & make some changes to the database.
Click to expand...

This has nothing to do with users vs. administrators. It would seem to
be because you're not opening the database exclusively.

Use the Open menu option; navigate to the folder containing the
database; and use the dropdown to select Open Exclusive.

John W. Vinson[MVP]
 
M

[MVP] S.Clark

When you choose File / Open from the the main menu, the dialog box has an
Open button, which also behaves as a combobox. Silly implementation, but
nonetheless, if you click to open the list, there is an option to Open
Exclusively.

Try to open the database that way, and see what other error messages
surface. If none, then you have it opened exclusively and should be able to
make the changes.
 
C

Charles L. Phillips

Hello,
"Thank You" for the procedure, but it did not work.
I still get the same message.
 
C

Charles L. Phillips

Hello,
"Thank You" for the procedure, but it did not work.
I still get the same message.
 
Top