Locking entire table

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

Hello,

I have about three people are occassional enter and
modify data into a table. There was in instance where
two people were entering data in at the same time and
some of the data somehow got mixed up. What I would like
to do is to lock the table so that when one person goes
in, they lock the table for themselves. The lock is
removed when they exit. Is there a setting that locks a
table?

Thanks,

Chuck
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You really don't want to do that.

It sounds as if you have all users who use the database using the same
front-end interface. Is this correct? If it is then you have to split
the database (into a front-end [queries, forms, reports] and back-end
[data]), if you haven't already, and give each user their own copy of
the front-end. To split the database use (Access 2002) Tools > Database
Utilities > Database Splitter.

For locks you should use the optimistic locking scheme, which is the
default. To check (Access 2002) Tools > Options > Advanced Tab :
Default Record Locking - select "No locks." If you want, you can lock
an edited record by selecting "Edited record." This will lock any
record that a user is looking at & editing, but allow other records to
be edited.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQkCJ6YechKqOuFEgEQJctACgm+eLmpQzsQJMpty35OlsjELppyYAnj54
B8cru94pgFZ9X4TxLtHaTyAe
=00q9
-----END PGP SIGNATURE-----
 
Back
Top