Lock Table When Form Open?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to lock a table when a form is opened? I would like to grant
exclusive rights to a table (tied to a form) when the form is open.

Any help that you can provide is welcome. Thanks in advance.

G
 
There is a form property on the 'Data' property tab called 'Record Locks'. It
defaults to 'No Locks' on all forms. Changing it to 'All Records' will lock
the underlying table when the form is open.
 
You must log in or register to reply here.

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

Separate Form 0
Linking a Form to another Form Problem 1
Opening form unexpectedly closes other form 0
Help with form load 5
Wizard unable to open form in Form or Datasheet view 1
Lock a form 3
Open another form if field checked in one form 1
Access 2003 pivot table subform 0

Back
Top