Recordset Locking

I have a VB6 App adding records to an Access/2000 database using ADO recordset with adLockOptimistic. THis should permit multi-user access but ot only permits one user accessing the database at a time.

Why?

Any suggestions would be greatly appreciated.

Thanks

JerryL

check this link