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.
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]
