Table Design security

[Guillem Serra]

There is a way to hide the table design view to some users, keeping is
ability to read/write/update data?

also I want to hide the relationships window from the same users.

(In short, I want to protect the Data Structure from the view of non
authorized users)

Thanks in advance

Guillem

 

[Scott McDaniel]

You can use RWOP queries for **ALL** data access (assuming your data is
split), then remove all rights to the tables. Of course, you must have
properly enabled security also. You must then base your forms, reports, etc
on the queries you built and NOT on your tables. For more info on this,
Google on "MS Access RWOP".