Client/Server Applcation For Large Network With ADO & Access

[Victor Cheung]

The Following Code Is How I Use:
Jet + ADO to connect to the access database on a windows 2000 file server..
any suggestion on how to improve it.. and what is the different between

adopenstatic and adopendymanic? any detail information on the ADO connection
string?

Anyone have experience on writing the error trap for ADO?

Goal: If the database is using by someone.. automatically wait a few
second.. and retry.. ?

Thankz..


Dim conn4 As ADODB.Connection
Set conn4 = New ADODB.Connection
conn4.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=z:\comtech\rm\rmbill1.mdb; Jet OLEDBatabase Password=" &
userpassword


Dim rmbill As ADODB.Recordset
Set rmbill = New ADODB.Recordset
rmbill.Open "select * from RMBILL where (tablenum='" & transfernum & "' and
saletype='" & transection & "' and status='O')", conn4, adOpenStatic,
adLockOptimistic

 

[Tim Ferguson]

what is the different between

adopenstatic
Snapshot

and adopendymanic?
Dynaset

any detail information on the ADO connection string?

Try the help files. While we are on the help file, is there any reason that
you are using ADO to manage a Jet database anyway?

B wishes


Tim F