I am working on a fairly low volume site that uses Jet4.0 and Access .mdb type
files. Advice, informative books or URLs would be greatly appreciated.

The DB was recently corrupted. As near as I can tell by system logs two users
logged in at almost the exact same time. The login procedure updates the
number of visits record in the DB. The table is opened with adOpenDynamic and
adLockOptimistic.

As I understand, jet uses a type of block read/write that may lock more than a
single record. Is it possible the DB was locked when user #2 and so the
corruption?

Advice, information or examples on good error trapping routines would help.

TIA

yabba
yabbadoo bigfoot com