Hi everybody,
How can i made a Row.Level locking using ADO for Access 2002?
How inizialize my connection? my code is this:
    strcnn = "Data Source=" & serverPath & "\WINLAB97.mdb;"
    Set cnn_Sistema = New ADODB.Connection
    cnn_Sistema.Provider = "Microsoft.Jet.OLEDB.4.0;"
    cnn_Sistema.Properties("Jet OLEDB:System database") = App.Path &
"\system.mdw"
    cnn_Sistema.Properties("Jet OLEDB:Database Locking Mode") = "1"
    cnn_Sistema.CursorLocation = adUseServer
    cnn_Sistema.Mode = adModeReadWrite
    cnn_Sistema.Properties("User Id") = UserName
    cnn_Sistema.Properties("Password") = Password
    cnn_Sistema.Open strcnn
I try with this code but the when modify one record with
cnn_Sistema.begintrans
'
'
cnn_Sistema.execute strSQL
'
'
cnn_Sistema.Commitrans
an athor user not can modify the records about a table that I modify

Tahnck u for a reply