progressbar and loops. Urgent!

[audface]

It's my first time in VBA. My program imports raw data and adds them into main table after validation.

It took me 2 or more hours just to validate and copy 3000 records into the main table daily and I think is tremendously slow. What can be the problem? There'll be more records to validate in the future. I indexed all fields in the tables.

While processing, the Task Manager on the OS showed "Not Responding" status and turned into "Running" status after the whole processing is done. Meanwhile, user will think that the application has hanged after waiting long and forcefully terminate it, causing discrepancies to data. I used syscmd but it does not respond at all during processing. What can I do to indicate that the application is still running? By the way, I have loops in the program. Can I really insert progressbar or syscmd or an animation into the loops?

Thanks in advance.

Cheers
AN

 

[nicsin]

Yes you can but the most important thing, as I understand your situation, is to also include DoEvents in your loops. IF you need more assistance with ProgressBar please post back. If you can post some code as well to give us an idea of what you are trying to do.

 

[jrbarnett]

audface,

There is no point indexing every single field or combination of fields. They will slow down inserts and appends as it means that the indexes have to be updated.
It is only worth indexing fields that are likely to be searched and sorted on that are not specifically the primary key of the table.

John