By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,972 Members | 1,115 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,972 IT Pros & Developers. It's quick & easy.

Is there a way to make a table read only?

P: n/a
Anyone know of a way to make a table read only after data has been entered?

Message posted via
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Once the data has been entered:
1. Open the table in design view.

2. Open the Properties box (View menu).

3. Beside the table's Validation Rule in the Properties box (not the
Validation Rule in the lower pane of the table design window, which applies
to a field), enter:

4. Save, answering No to the question about testing existing data.

The Validation Rule is an expression that evaluates to True or False. Since
this expression is always false, Access won't allow any entries or
alterations. You will need to prevent deletions in the form (set
AllowDeletions to No.)

If you need to do this programmatically, CreateProperty() on the TableDef().

Of course, full-blown Access security is the more comprehensive solution.

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
Reply to group, rather than allenbrowne at mvps dot org.

"Jonathan Snyder via" <fo***>
wrote in message news:50***********
Anyone know of a way to make a table read only after data has been

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.