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?

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
 
Back
Top