I have created a few forms in Access. How can I prevent user from opening the table, view and edit the table ?
I am using access 2007.
I have created a few forms in Access. How can I prevent user from opening the table, view and edit the table ?
I am using access 2007.
You might find this link useful: http://www.btabdevelopment.com/ts/de...aspx?PageId=95
Thanks for the link.
Other then hiding, is there any other way to password protect the table ?
If the person who uses the form knows their way around, he can still view and change the data in the table ?
You are correct. The only *real* solution that would work is to use a different BackEnd like SQL Server.
The short answer is, if anyone knows their way around access there's no way to prevent them from using the back end tables unless you only give them the run time components to run the database. If your users have full versions of access installed there's no clean way to prevent them from touching your tables directly.