Hi!

I have VB3 accessing a Access 1.1 database.
There are about 30 users, accessing a single database about every minute.
When they access the database they lock the database as follows

Do while database locked
Doevents
Loop
Lock database
Update
Release lock

This worked fine for about 15 users.

But now some times they get database is read only errors.

I suspect that the process that checks if the lock is free passes okay,
but another user nips in there and locks the database before the process
that has just checked the lock has chance to lock the database.

Is there any way to check if the lock was sucessful, then If the lock was
not got cleanley the process could try again.

Thanks

Another alternative would be to upgrade to Jet 2.x or Jet 3.0.
Both have much improved support for multi-user applications.

Joe

Never underestimate the power of a WAG.

http://www.citilink.com/~jgarrick