Access Security

[TheUnderTow]

I am attempting (underlined, in bold) to enforce some security on a database without using the user level security package in access (I have a lot of db's and it would be inefficient to do that). Basically, I have a table of users with password, NTLogin and Access_Level information which I am trying to use to determine which forms, tables, reports etc. can be accessed. Can anybody advise on VB code which can be executed from a form which will restrict access to opening forms and reports based on the user's access level? If this is overly complicated then please say and I'll see if I can simplify it!!

[OBonio]

Something like this?

http://www.programurl.com/lassie-light-applica tion-security-for-ms-access.htm