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 Lock File .LACCDB / Now shows as a notepad file 0
Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0
Table Security in Access 2013 1
User Security in Access 2007 2
Securities 0
Username Password Issues 0
Which MS Program to Use? 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0

Top