Access 2000 Find to SQL Server

[LabPak]

I have an Access 2000 .MDB front end with Micrisoft SQL Back end using Linked tables (ODBC). The application will be used both over the LAN and by our field people via intrnet. The MDB was manually converted from Access 97 to Access 2000. Everthing seems to work well with the following exception.

When using the Access FIND (The menu button) the speed over the LAN is too slow! I.E. When searching a field with text that does not exist, it takes about 26 SEC just to come back with a not found!. If I use a simple Query with the same parameters, it is Quick!. It looks like Access 2000 Find (search) does not package up an SQL string but reads every record into the client to see if ti find criteria is met!!!

I am using only the ADO libs. I tried DAO as well but with no help.

Is there a replacement for Access Find available that packages up a SQL string to send? Is there a better way of doing this? Do I need to write my own Find to get around this?

HEALP!

 

[Pat Hartman]

Run a parameter query rather than using the Find Method. Here's a DAO example. This cannot be converted directly to ADO. I haven't figured out how to accomplish this with ADO since it doesn't support the Parameters property.

Dim dbs As DAO.Database
Dim rst As DAO.Recordset
Dim qd As DAO.QueryDef
Set dbs = CurrentDb
Set qd = dbs.QueryDefs!YourQueryName
qd.Parameters![YourParm1] = "SomeValue"
qd.Parameters![YourParm2] = "SomeValue"
Set rst = qd.OpenRecordset