>im working on a project that uses a *.dbf file for its table. my concern is, is there anyway i can speed up the recordset access from the free table? i used SQL statement already instead of the sort,filter method and yet it takes me about 2mins just to bring up the form that displays the data from the remote table.
>
>im sure there is a better and faster way to access the recordset using ADO, and anyone who can help me with it, that would really be great!
The thing is that even if your query ("SELECT * FROM empfile WHERE empno = '" & sEmpNo & "'") returns only one record, the whole table will go through the network and then the Where clause will execute locally because dBase files don't have remote database engine. The server is only there to share the file.
The best you can have is to upgarde to MSDE, SQL Server, Oracle, DB2, ... or any other real database engine (FYI, Access is not a real database engine!).
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com