Possibility to lock the records after the updates in Access database

Asked By warriorfullight 0 points N/A Posted on - 01/09/2012

Is it possible to lock the records after the updates in Access database? I also would like the interface to show only a certain form for the user to fill out.

• Status: Open
• Question Views: 733
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Aristono Martin 20 points N/A #91012

Possibility to lock the records after the updates in Access database

It is possible to lock records in Access database. This is due to the fact that it is very easy to overwrite, delete and change data accidentally in Access. You may try to set a form ‘AllowEdits property to prevent or not allow the changes made or you may also lock any unbound control via filtering or navigation. Please go to this link which can be helpful on your query http://allenbrowne.com/ser-56.html. What it will do on the form and database is it will lock the bound control on a form and handles the same thing on its sub forms as well.

About Aristono Martin

Questions
3

Answers
370

Best Answers
53

• Vote Up 0 Vote Down

• Posted on - 01/09/2012
• Question Category: MS Access