i have a MDB in a multi-user-environment (5 user) and use OLEDB to manipulate data.

in some situations (unpredictable), a user gets a
3218 ("Update not possible, currently locked")
from the JET-Engine when executing e.g. an INSERT-command

til now, i used the connection string
gCnnM.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & DataBase & ";"
without further settings.

could it be, that there is a default of "Page-Level Locking" for the property Jet OLEDB : Database Locking Mode ?

or has anyone an idea, where my problem could be ?

generally: where can i find the default values for the ADO-properties when connecting to an Access-Databse ?

THX for help !!