keep users from opening tables directly

[dpimental]

all, I have an access 2007 db front end which I distribute copies to users. I want the users to be able to have access to the navigation pane; but not to open the tables directly.

I don't just want to hide the tables, unless there was a way for them not to be able to unhide them.

Any ideas or code to keep users from opening and / or editing table data directly?

David Pimental
(US, Oh)

 

[vbajock]

http://www.techrepublic.com/blog/10things/10-tips-for-securing-a-microsoft-access-database/552