Setting Security Levels in Access 2007

0
votes

I have created a split database in Access 2007 and need to set user level security. I don't want the users to have access to any of the tables or queries etc. I've created a form so when the database is opened it automatically opens where the user can choose an application to run. How would I go about setting the security levels for each user?

1
ms-access-2007
Have you read the Jet User-Level Security White Paper? That's the starting point for all Jet ULS. But it's pretty easily crackable so if you need real security, you likely need to store you data in something other than Jet MDBs. – David-W-Fenton

1 Answers

0
votes

I found the below links using Google. Bit sarcy but it would always be my first port of call without further info or details in a given question showing research already done.

MS1, MSblogentry