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:
False
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 -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Jonathan Snyder via AccessMonster.com" <fo***@nospam.AccessMonster.com>
wrote in message news:50***********@AccessMonster.com...
Anyone know of a way to make a table read only after data has been
entered?
