Set Passwords - Access 2007 (1 Viewer)

[kostaskir]

Hello guys ,


Do you know how can I set passwords with different privileges in an Access 2007 ?


Thank you.

 

[DJkarl]

Access 2007 and later editions removed ULS (user level security) from the new format databases (accdb, accde, etc). They still support it for older databases that have ULS and use the MDW files. If you want to use the new database format you would need to create your own login system and handle it through code.

Here are some basic ideas from MS on how to secure an A2k7 database.
http://office.microsoft.com/en-us/access-help/help-secure-an-access-2007-database-HA001230187.aspx