Slow opening form with ado and large recordset

[cab]

I'm somewhat new to ado and am having a problem opening aform. It takes over a minute to start when I use 'SELECT' to gather all the records... is there a better way. Below is a snippet of the code.


Private Sub Form_Load()
Dim db As Connection
Set db = New Connection
db.CursorLocation = adUseClient
db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;" & "Data Source=f:\Clear\Clear.mdb"

Set adoPrimaryRS = New Recordset
adoPrimaryRS.Open "SELECT * from FsrData,CustList WHERE FsrData.ServCust=CustList.CustNum", db, adOpenStatic, adLockOptimistic

Any help or ideas to speed up entry into the form would be appreciated
Colin

 

[petermeachem]

Crikey, how many records are you displaying. It looks better if you show the form first and then display the data. If you are subsequently selecting a customer and showing the data for that one, then don't display any data when the form loads, wait until the selection. Also have a look at the indexing on the tables. Is it mega slow in Access too?

 

[cab]

Thanks

No its not slow in Access... its about 26000 records.

I display one record on the form.. and a Data control to scroll through the records

I've set each Text Object to a DataField..

Colin