Preventing users from opening and viewing the design of the tables

[Wael K]

Dear Everyone.
I have created a database containing forms that rely on queries that rely on
tables.
I ran the security wizard and wish to prevent people from accessing or
viewing the design. When I select allow users to edit, add or view data
Access automatically select view table/ design which allow users to see the
design or alter the data in the tables. If they alter data in the table the
written code will not trigger and some data will get corrupted. Data should
be updated via the forms only.
Hiding the tables does not help, access topics are evrywhere and anyone can
get the tables back.
All I need is to force the user to enter data from the form window. In
earlier Access 95 or 97, whenever someone tries to enter data in Northwind
tables, a message popups informing the user that data can only be entered via
forms.

Please HELP !!!!!!

Yours truly
Wael

 

['69 Camaro]

Hi, Wael.

When I select allow users to edit, add or view data
Access automatically select view table/ design which allow users to see
the
design or alter the data in the tables.

Don't do that. Remove all permissions on all of the user tables from the
users, including the permissions to read or update the table design or data.
Create queries with the RWOP (Run With Owner's Permissions) attribute. Have
the forms be bound to these RWOP queries. The users will be able to run the
queries displaying the data within the tables when the forms are opened, but
the users won't be able to directly access the tables.

If they alter data in the table the
written code will not trigger and some data will get corrupted.

You can probably alleviate much, if not all, of that problem by enforcing
referential integrity and adding Validation Rules or constraints (via SQL)
to the tables.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.