Question User access control in Access 2007

[Gemma Khan]

Hello,
I want to implement user access control in access 2007. I want that only administrator of DB can open objects like forms, tables, queries, etc. in design view and tables & queries explicitly. I mean other users should only interact with these objects through Forms and users can open selective forms only (specific forms for specific users). In access 2007, when I press F11 button, Navigation Pan opens up (which should not be except for administrator user). How can I do that???
Thanks

 

[Galaxiom]

The only sure way to keep others out is to convert to a compiled distribution format such as MDE or ACCDE.

There are several recent posts here on partial protection techniques.

 

[SOS]

The only sure way to keep others out is to convert to a compiled distribution format such as MDE or ACCDE.

Unfortunately that doesn't include protection from modification of tables or queries; only forms, reports, macros, and modules.

To protect it further you will need to disable F11, and use the disablebypasskey (we just had a post on that here, so do a quick search on that term).

And even then it won't be secure, secure. Access databases are not real secure. If you really need security, move to SQL Server as the backend, where you can apply real security, and use Access as the frontend.