Speed Up Queries

[Guest]

I am convering a Access 2K project that will now be using SQL tables for
storing the back end data.

I just read info about the upsizing wizard which had some info on how to
design new queiries using "Where" so that this runs on the sql server.

I have a query that is slow. (See Below) I could use help with the syntax
to change this so that it is more effecient.

Private Sub Combo90_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[Company] = '" & Me![Combo90] & "'"
Me.Bookmark = rs.Bookmark
Me.Filter = "[Company] = '" & Me![Combo90] & "'"
Me.FilterOn = True
Me.Refresh
Set rs = Nothing
End Sub

Can I use the query wizard in Access 2 K to write this query with the Where
Clause?

Thanks in advance.

 

[Jeff Boyce]

I seem to recall that the .FindFirst method works on local (i.e., inside
Access) tables, not linked tables.

Have you tried creating an actual query, using the query design window?

Is your SQL table indexed?

How fast is the network connection to the SQL tables (if they are not on
your local PC)?

Are you using any Access/Jet-only functions -- SQL doesn't know how to
optimize these.

Just a few thoughts...