
Row-Level locking in Access 2002 e VB6
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