Security in Access 2007 ???

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
 
A

Allen Browne

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access convert ms access 2007 database replica to design master 2
LastPass security flaw identified 0
Why do I have to enter my password everytime I open Access? 2
Access Issue, Macro Single Step, Error 3270 0
User Level Security in Access 2007 8
Confused with security set up 3
Access AutoExec, Runcode Error 2001 1
Convert Access 2003 with security to Access 2007 2

Top