If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Access > How can I log into an Access database as Administrator so I can modify the database?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Jan 2004
Posts: 64
Question How can I log into an Access database as Administrator so I can modify the database?

How can I log into an Access database as Administrator so I can modify the database?

I need to make design changes to a database that was created by somebody else.
When I open a form in design view I get this message:

“You do not have exclusive access to the database at this time. If you make any changes, you may not be able to save them later.”

When I ignore this message and open the form in design view anyway the next message I get is this:

“You don’t have permissions to modify ‘form name’.
To modify this object, you must have Modify Design permission for it. If the object is a table, you must also have Delete Data and Update Data Permission for it.
Do you want to open as read-only?”

What do I need to do so I can make design changes?
Note: When I open the database I hold the shift button down so I can have access to design.

When I try to view and change my user permissions in Tools/Security/User and Group Permissions I get this message:
“You can’t view this object’s permissions. …..”

How can I login as Administrator so I can modify this database?

Thanks for your help.
Reply With Quote
  #2 (permalink)  
Old
Purveyor of Discontent
 
Join Date: Mar 2003
Location: The Bottom of The Barrel
Posts: 6,102
Who made the database?

You are better off taking the human approach to getting access then trying to hack it open, which is what you're proposing.

That security exist(s/ed) for a reason. Talk to the person who made it.
__________________
oh yeah... documentation... I have heard of that.

*** What Do You Want In The MS Access Forum? ***
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Jan 2004
Posts: 64
I'm not trying to "hack" it open. I work here and this is a project given to me to add new stuff to the forms.
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Oct 2004
Location: Melbourne, Australia
Posts: 201
Try this. Create a new blank database. Create a new security table (through the Workgroup Administrator item in the Database Utilities/Security menu) and "join" it, so that it applies to your database. Then open the other database and export each object to the new database. Then you can set yourself up as Owner and make whatever changes you want. Very tedious, but what options do you have ! ?
Reply With Quote
  #5 (permalink)  
Old
Moderator
 
Join Date: Dec 2004
Location: Madison, WI
Posts: 3,925
NO!! Don't implement MSAccess Security!!

The reason you are getting this message:

“You do not have exclusive access to the database at this time. If you make any changes, you may not be able to save them later"

is because someone else is in the mdb file!! If you ignore this message, you'll get the next messages you posted when trying to save.

You can't make design changes on an mdb form and save them while someone else is in that same mdb file and using it. You'll get the same error if you're trying to edit the table design and someone else has that table open (via a form, query, etc...)

You must make sure EVERYONE is out of the mdb file before you get into it to make any design changes. Otherwise you can easily corrupt the mdb file (you should also compact/repair it occasionally.) If there is an *.ldb file in the same folder, someone else is in the mdb file and you shouldn't open that same mdb to make design changes!! If you do open and try to design, MSAccess gives you a nice warning "You do not have exclusive access to the database at this time...."

(this is where you setup a "Development"/"Deployment" type system (ie. folders) if you need to periodically edit mdb files which users need to also open simultaneously.) You make your design changes on the (frontend) mdb file in the "Development" folder and then copy the new frontend mdb file to the "Deployment" folder (when everyone is out of the frontend mdb file - ie there's no *.ldb file in that folder.) You must also make sure you have a frontend/backend mdb file (where the tables are in the backend mdb and "linked" into the frontend mdb file) - then you don't have to worry about transferring of any data when you copy the new frontend mdb file (you just refresh the linked tables if necessary after copying the new frontend).

I'm guessing there were no security permissions implemented (unless you also have an mdw file). If you DID implement mdw MSAccess security permissions trying to get into the mdb to override the above problem, now you've got a NEW problem (ie. MSAccess security and an mdw file.)

If there was no *.ldb file in the folder before you opened it for designing, then you're most likely dealing with MSAccess permissions (but you will not get this error: "You do not have exclusive access to the database at this time"!) - instead it will say something to the effect of permissions (not access to the mdb).
__________________
Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Last edited by pkstormy; 08-23-09 at 19:21.
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
Join Date: Nov 2011
Posts: 1
.mdw

PKstormy should look at that again. I copied the database and the .mdw file from the server to my desktop to make changes without interrupting the users, and I still got that message. It is because the person who made it restricted rights to everyone but him. At Teddy, people come and go in businesses just like this one, the maker was let go from this company, so hacking into something someone left for someone else to clean up is becoming reality, as I am sure you are aware. Thanks Jim Wright, that is the sanest answer I heard so far. I am in the same boat, only he created logins for the users, so I am struggling trying to find out how to create, delete, add users to this database, and get someone set up on a new machine. Also, I need to change permissions for someone who is already a user. I think Jim is right, need to remove users and permissions all together and restart from scratch. I am playing with the copy before going down that road first.
Reply With Quote
  #7 (permalink)  
Old
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 11,645
there's two separate messages
Quote:
“You do not have exclusive access to the database at this time. If you make any changes, you may not be able to save them later.”
means that you are attempting to make changes to an Access applciation (form, report, tables, queries etc) whilst someone else has the applciation open
..bad idea as it means you are developing on a live database application object. changes should be made in a separate access file, and once tested and proved applied to ta live application file.
..in an ideal (Access) world you have a minimum of 4 files
a back end containing the data
a front end containing the user interface (forms, reports etc)
a duplicate of both those files as a development environment
..some may argue another set as a quality control test / QA environment before deploying to live / production status

the rest of the messages the OP reported all track back to that initial attempt to make changes to a DB that someone else was in.

what you are experiencing is a slightly different wrinkle
Access used to implement security using a workgroup file (its been dropped from 2007 on), where the developer assigns specific roles to specific usergroups and users within those groups. if you havent' defined a workgroup then everything by default is assigned to the user 'admin' with a null password.

if you are locked out of an applciation becuase of usergroup security issues then you need to do as Jim Wright suggested and copy all of the objects into a blank db, assign a new workgroup file and then reassing the security permissions

you add / change user permissi0ons by changing the workgroup file. tools | secuirty |.....

but before you contemplate changing the security make certain:-
you read the MS Access Security FAQ.
take a back up
then read the MS Access Security FAQ.
verify your backup works
then read the MS Access Security FAQ.
make changes
do some testing
then read the MS Access Security FAQ to find what steps you missed out
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
Reply With Quote
  #8 (permalink)  
Old
Registered User
 
Join Date: Nov 2013
Posts: 4
Talking open the dbase exclusive

ms access 2010
close the dbase
open Microsoft access from the start menu
click on the file tab
Click on [open]
when the windows open dialogue box appears, go to the location of your dbase and highlight the file
at the bottom right of the open file dialogue box is a button marked open with a dropdown arrow on it's right hand side.
click on the dropdown arrow and select "open exclusive"
that's all there is
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On