Locking a Database file

  • Thread starter Thread starter Glynn
  • Start date Start date
G

Glynn

I have an accounting application where I save each accounting year
separately, as a database file in an 'Annual Accounts' folder - and proceed
on with the current year form carry-down balances.

I want to secure the integity of each 'saved' year, by preventing any
further data input into thoes year, but leaving them open for viewing ie., I
want to lock the database against any data input.

Appreciate how I could 'lock' the database file against input, but leave it
open for viewing.
 
One approach would be to use Access security, so no one can get it.

If you are just trying to prevent accidental changes (not worried about
malicious intent), you could add an impossible validation rule on each
table. Use the rule for the table (in the Properties box in table design),
not that of a field (in the lower pane of table design.) For example:
Validation Rule: False <> False
Validation Text: No changes allowed. Press <Esc> to undo.
 
Back
Top