Lock a table but allow queries to be edited

  • Thread starter Thread starter Filo
  • Start date Start date
F

Filo

Hi -
I have what is probably a question. Is it possible to lock down permissions
to edit a table but allow users to edit queries? Thank you.
 
Hi -
I have what is probably a question. Is it possible to lock down permissions
to edit a table but allow users to edit queries? Thank you.
Click to expand...

Yes... but just be sure you realize that editing a query does edit the
underlying table; the query has no independent existance.

Ideally users should never have the option to see either table or query
datasheets, much less edit them. A fully professional Access database will
have security set to limit users to Forms, usually based on queries. See the
discussion of "with owner permission" in the Security FAQ:

Microsoft Access 2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

John W. Vinson [MVP]
 
Back
Top