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



Sun, 01 May 2005 01:21:54 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. record level locking (access 2002)

2. Access 97 Row-Level Record Locking

3. row-level locking with dao and access 2000

4. Row level locking with an Access 97 DB ?

5. VB6 and Office97 ACCESS and Office 2002 ACCESS

6. Command Object vs Connection Object for Row Level Locking

7. Command Object vs Connection Object for Row Level Locking

8. Row Level Locking Help???

9. Row Level Locking

10. How to do record/row level locking?

11. How do I apply row-level locking in SQL server with ADO

12. DB2 & VB Row Level Locking

 

 
Powered by phpBB® Forum Software