Hi:  Is it possible to make a table read only when it is open?

Generally, users should not have access to the tables at all.  They should
be working in forms.

You can take away all access from a table by a user.  You can create a saved
query that pulls the data you need from the table and set that query to "run
with owner's permission".  You can then base your forms on that query and
give the users the appropriate access.  This keeps them from messing around
in the table and bypassing all the security you have built in your form.

Rick B

Show quoteHide quote

Please confirm security limitations
"Error changing owner of database"
Prompting for password
i give up...please tell me how to remove security
samad najafi
Exclusive access
Identify who updated field
Users and Groups list empty
:: Control user access
Auto Backup