Greetings to All,

This is a call from belgium, could you help me?

My problem is very simple, hope that the solution will be
the same :-).
My database is stored on a NT server with 3 workstations.
All the users have access to the database.
Oke, thats no problem, but how can I lock the record
when a user accessed it?
In DAO the locking works but the whole table has been locked instead of that specific record.
I changed the project in ADO with adLockPessimistic and
it's not working, everybody can change the same record.
Is there someone familiar with multi-user programming and
could tell me how it works?
Perhaps a small piece of test code should help me a lot.
I'm using MS Access 2000, Visual Basic 6 Pro, no datacontrols on the form and running MDAC 2.5.
I'm using SQL to access the tables.

Thank you for your time.