Multi User VB 6.0, ADO, Jet 
Author Message
 Multi User VB 6.0, ADO, Jet

Hi All,
I' new to VB but have written a large application in VB 6.0 that it is to
installed on a Network but I am now testing under Windows 98.

This new system is going into  the "testing phase" but  I am unknowlegeable
about the record locking methods with Jet/VB 6.0/MDB files.  Although I
thought I locked the record with adlockPessimistic and then use a Sql
statement to get the recordset, "THE SECOND USER IS ABLE TO UPDATE THE EXACT

On the other software I develop in, this would crash if two applications
were accessing the same record.

Here is just a small section of my code that shows the method I am using.

         Set rstQuote = New ADODB.Recordset
         rstQuote.CursorType = adOpenStatic
         rstQuote.LockType = adLockPessimistic
         rstQuote.Open "Select * From Quotes where quoteid =  '" &
MDIForm1.cQuote & "'", cnn1
         rstQuote.Fields("FieldtobeUpdated").Value = form1.cbobox.text

All comments are appreciated.
Orlando, Florida

Tue, 31 Dec 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. ADO With Jet Provider, Multi User Hell, Please help

2. Multi User database using MS Jet 4 and ADO

3. VB ADO Multi-user problems

4. VB ADO multi-user issues

5. VB/Access2k/ADO/MULTI USER!

6. VB ADO multi-user issues

7. VB/Access2k/ADO/MULTI USER!

8. MSDE vs JET 4.0 Multi User et al...

9. Multi-User Client Server (Urgent) Jet?

10. multi user with jet DB

11. Jet for multi-user systems

12. Jet Engine Multi-User features


Powered by phpBB® Forum Software