Visual Basic Database

[Ann Cronin]

Hi

I have a program that is used to pull information from one database table to another and i need some code to slow down the process as at the moment the program is running to fast and is not pulling all the required records on the first pass. Does anyone have any solution for this. The size of the table is between 3,500 and 5,500 records and can vary.

Any help would be great

Ann

Ann Cronin

[jaredy]

Depends. Are you using ADO or DAO. I am assuming that you are opening a recordset. If so, request the record count. That will force JET to read the entire recordset.
However, if you are just moving data (not doing a bunch of manipulation of it in between) then I would just use a SQL query that would do the work for you. You might search INSERT in MSDN.

[Ann Cronin]

Hi,

I'm using ADO. I have a recordset open. For some reason even though i have the criteria set all the information is not pulled on the first pass. I have already requested the recordcount in the code and it is looping through the code until the .eof is reached.

Ann Cronin

[jaredy]

If you send me the code and zip up the database I would be happy to look it over for you. I've been doing database conversion for several years and should be able to find your problem for you.
My e-mail is j.youtsey@efortress.com
If you are using ADO be sure that you are not using any adobatch* options in your open command.