Restricting Access to Tables

[durdle]

Good day,

I am looking for a way to restrict end users to access tables/queries/modules. The users have Access 97 installed on their machines. I am not sure how to split the database, I believe you need the developers verision of Access?. If I created an MDE file, this would not limit the access to the tables.??

Any suggestions would be great.

Thanks
________
plymouth concord specifications

 

[o1110010]

I am looking for a way to restrict end users to access tables/queries/modules.

If you disable certain special keys (ie F11) and make it so the database window does not show, half of the battle of protecting those objects is done. You probably will have to make it so forms only open in Form View as well as the equivilent to the reports. *ponders* That should do it. The Access guru's can correct me if I'm wrong.