Making a table read only

[Jim Pockmire]

Having created a table, is it possible to make the table read only (aside
from using workgroup security)?

 

[Rick Brandt]

Having created a table, is it possible to make the table read only
(aside from using workgroup security)?

Not really. If your users are clueless about Access you coudl name the table
with a USys prefix which will cause it to be hidden as a system table and then
you could access the data only with code. Experienced users might know to look
for this (if they have any reason to).

Another option is to put the table in a separate mdb and link to it. The
separate mdb could be placed in a read only folder on the network.

 

[Eric Schittlipz]

Having created a table, is it possible to make the table read only (aside
from using workgroup security)?

Would you consider not allowing direct access to the table? Perhaps use a
form designed with a default view of 'datasheet view' where the form does
not allow edits, additions or deletions. Or how about a read-only query, or
use code to open a standard query as read-only? If none of these options
suit, and you don't want user-level security then your options get slightly
less standard like using Windows permissions.

 

[Jim Pockmire]

The mdb consists of data archived from a mini. I want to give people the
ability to create their own queries, but not tamper with the data. A read
only folder for the data seems like a good option, with links to it.