Row Level Locking 
Author Message
 Row Level Locking

Which component makes row level locking now possible:  Access 2000 or Jet
4.0  (what I'm getting at is can I use Jet 4.0 against an Access 2.0 or 97
database and use row level locking.)

Thanks.
John



Mon, 24 Jun 2002 03:00:00 GMT  
 Row Level Locking
You can achieve row level locking with Jet 4.0 and an Access 97
database.  I am not sure about an Access 2.0 database.

-Dan Beacom

On Thu, 6 Jan 2000 15:06:57 -0600, "John Cleary"

Quote:

>Which component makes row level locking now possible:  Access 2000 or Jet
>4.0  (what I'm getting at is can I use Jet 4.0 against an Access 2.0 or 97
>database and use row level locking.)

>Thanks.
>John



Tue, 25 Jun 2002 03:00:00 GMT  
 Row Level Locking
no, row-level locking is only supported for Access2000/Jet4 databases.
Access 2 and 97 use page locking. the reason for this is that the file
formats/storage between the versions is completely different.

On Thu, 6 Jan 2000 15:06:57 -0600, "John Cleary"

Quote:

>Which component makes row level locking now possible:  Access 2000 or Jet
>4.0  (what I'm getting at is can I use Jet 4.0 against an Access 2.0 or 97
>database and use row level locking.)

>Thanks.
>John



Tue, 25 Jun 2002 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. row-level locking with dao and access 2000

2. Command Object vs Connection Object for Row Level Locking

3. Command Object vs Connection Object for Row Level Locking

4. Row Level Locking Help???

5. Row level locking with an Access 97 DB ?

6. How to do record/row level locking?

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

8. DB2 & VB Row Level Locking

9. Row-Level locking in Access 2002 e VB6

10. Command Object vs Connection Object for Row Level Locking

11. Row-level locking

12. Row level locking use system stored procedure via ADO

 

 
Powered by phpBB® Forum Software