Locking Records

R

Rick V.

Once you save a record, how can you lock it so that the
user can't mistakingly change the record? I am runnig
Access 2000.
 
C

Cheryl Fischer

If what you want to do is add new records but not edit existing records, you
can set the Allow Edits Property of your form to No.

hth,
 
R

Rod Scoullar

If you are referring to preventing the user changing data on a form you can
lock individual fields on the form by changing the Locked property to true
or prevent changes to any data on the form by changing the form AllowEdits
property to false.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Lock File .LACCDB / Now shows as a notepad file 0
2 Level Record Protection 0
How to clear areas of a locked Doc after each use-- 0
Table of content - format does not get saved 2
M.S. Word 365 1
Record Locking 2
Place picture in Excel cell 0
need help ASAP word 2016 recipient cant edit 0

Top