Adding Users

  • Thread starter Thread starter Emma
  • Start date Start date
E

Emma

Hi I have a database I started in MS Access 2003, added users to it. Then I
upgraded to 2007. So my question is now, how do I add more users to the
security file? Since I can't seem to open it using 2007.
 
On Mon, 22 Jun 2009 08:29:03 -0700, Emma

When you upgraded, did you keep the MDB file format, or did you switch
to ACCDB?
I'm guessing the latter, which does not support user-level security.
You need to keep the former. Then the security tools are on the
Database Tools ribbon.

-Tom.
Microsoft Access MVP
 
In a secure MDB opened with Access 2007, you can get to the security dialogs
with:
RunCommand acCmdUserAndGroupAccounts
RunCommand acCmdUserAndGroupPermissions
 
I think I'm going to open up the 2003 file change the users then physically
copy and paste the security file
 
Hi Allen,

It did work by me going back to a previous version editting the security
file then copying and pasting. But I am interested in your way of doing it
also. So my question to you is where do I put the run commands? I tried in
the VB part of the program but nothing happened. Can you help me?
 
Just create a form with a couple of command buttons, and use the RunCommand
in the Click event procedure of the buttons.

Unless you tell A2007 that you trust the folder where your database resides,
you may find that no code runs. To trust your folder, click:
* Office Button (top left)
* Access Options (bottom of dialog)
* Trust Center (left)
* Trust Center Settings (button)
* Trusted Locations (left)
* Add new location (button)

This assumes we are talking about an MDB (not the new ACCDB format), secured
with an MDW.
 
Back
Top