In my accDB with tables linked to sql server I have a form where recordsource is a table with +60K records. When I use access "build in search" it is very slow (+60sec). In ADP the result is < 3sec.
Is ODBC/Linked tables not using table indexes, is there any way to speed up search?
I have tried creating custom vba search as below, its working but is really slow too.
Set rs = frm.Recordset.Clone
rs.FindFirst "[" & strSearchField & "] = '" & strSearchFor & "'"
frm.Bookmark = rs.Bookmark
Also when searching directly in tables linked tables are much slower than adp. Is this by design or could I be doing something wrong?