How to restrict the user from viewing Table?

[linsu]

I have a small Access database. The Tables, Forms are in the same database. Through the Forms, a user can insert, update, delete records.
I like to prevent the users from viewing tables. I tried to solve this by separating the tables into a different database and linking them in the other database which has all the Forms, etc. But, still a user can doule click on the table, open and view (and worst of all update the data in the table). The user level security also does not help. If I restrict the Updates in a table to a user, he can no longer update the record through the Forms.
I am just wondering if there is any way that I will not allow the users to open the tables by doule clicking, or by any means.
By the way, I am new to Access. Thanks in advance!!!

 

[JerryKlmns]

Hi linsu,

Search for AllowBypassKey in tek-tips, It 's an answer to your problem. Remember ---> Safety First keep a copy before you try anything.