Front end table access

[rob1234]

I split my database so that users could only edit/view data through the forms but when I opened the front end the tables where still there (linked though) and I could edit and look at them. I assume this is normal so how can I prevent users from seeing the tables. Do I just set them to hidden? Thanks.

 

[rob1234]

Can I prevent users from entering design view in the front end as well

 

[rob1234]

OK, I found the tools->startup thing. Is there anything else I should be considering.

 

[Pat Hartman]

Depends on how secure you need to make the database. You can use a start up form and hide the database window. If that is enough to deter your people from messing around, then you're done. If it isn't, you should consider securing the database to prevent them from interacting with objects except to use them in normal view.

Before you start working with security, it is IMPERATIVE that you make several backups and keep them in a safe place. You must also read the security FAQ that you can find in the Microsoft knowledgebase and follow its instructions exactly.