Record Lock for One Record

  • Thread starter Thread starter Zanstemic
  • Start date Start date
Zanstemic said:
I have a table with one record that needs to be locked.

Any suggestions?
Click to expand...

You can't really lock a table, which is why you either need to secure the
database (MDBs only) and/or hide the tables so that there's no possibility
of anyone seeing them, then lock the form containing the data. If there
could be anyone who will try to get in, use the ByPassKey lock to keep them
out of the hidden tables:

http://www.mvps.org/access/general/gen0040.htm
 

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

Record-Locking remains open after closing 0
Record Locking 2
Record locks 4
Turning a 3 column flat file into a "3D" Table 2
Append to new table vs Update one table 3
Record Locked Dialog Box 2
Locked Records 2
Locking single records in a table 2

Back
Top