|
-
Dec 21st, 1999, 03:05 AM
#1
First, I start Access 2000 and open an .mdb database( with option Default record locking set to "Edited record" and option
"Open database using record-level locking" set to True.
Second, I run 2 exe copies of a program written with VB6 in which I open (in pessimistic mode) a table in the above mentionned database (using DAO 3.6 objects)
and try to edit the same record. I can see that row-level locking works fine.
Now I close all running applications (Access 2000 included) , start again these 2 exe copies but without opening in advance this database with Access 2000 application; now row-level locking does'nt work. (instead,I get page-level locking)
My question: how can I get row-level locking
without opening database before with Access?
Thanks in advance.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|