Making a table read only

  • Thread starter Thread starter Jim Pockmire
  • Start date Start date
J

Jim Pockmire

Having created a table, is it possible to make the table read only (aside
from using workgroup security)?
 
Jim said:
Having created a table, is it possible to make the table read only
(aside from using workgroup security)?
Click to expand...

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.
 
Jim Pockmire said:
Having created a table, is it possible to make the table read only (aside
from using workgroup security)?
Click to expand...

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.
 
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.
 
Back
Top