i am creating a source code in visual basic 6, which happen to be that I am manipulating more than 1g of access databases 2000, i use a command find but it turn out that it is to slow in finding records, i want to use the command seek in finding my records what its the code use so i can use the seek command in my program....
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how can i use the command seek to my mdb access 2000 in my vb6 code.
- Thread starter clones
- Start date
How long does it take to find the record?
Are you using DAO or ADO?
If ADO, and this is a Jet MDB, then use a Server Side cursor for things like this:
rs.CursorLocation = adUseServer
Leaving out the Sort order will speed things up alot, and having a index on the criteria fields will also. [/b][/i][/u][sub]*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!
Are you using DAO or ADO?
If ADO, and this is a Jet MDB, then use a Server Side cursor for things like this:
rs.CursorLocation = adUseServer
Leaving out the Sort order will speed things up alot, and having a index on the criteria fields will also. [/b][/i][/u][sub]*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!
- Thread starter
- #4
- Status
