Security in Access 2007 ???

  • Thread starter Thread starter mthornblad
  • Start date Start date
M

mthornblad

Where is the security in Microsoft Access 2007 ??? In previous
versions you could set up passwords and privileges for Users and
Groups of users. How do you set up some kind of security so anybody
who uses it can't just delete the database ? I want some users to be
able to just make inquiries. I don't want everybody who uses it to be
able to destroy the database, even is it is by accident.

Please help !!
Thanks

Mark (thorny) Thornblad
 
MS has deprecated Access security (mdw files) in Access 2007. It is not
available in the new file format (ACCDB.)

If you use the old file format (MDB), click Database Tools on the ribbon,
and Users And Permissions on the Adminster group (rightmost.)

Programmatically:
RunCommand acCmdWorkgroupAdministrator
or
RunCommand acCmdUserAndGroupAccounts
 
Back
Top