hi all

I have a performance issue with a VB6 app connecting to an Access db using vb's Data Environment. Happens with a single user logged on, and in lots of different functions within the app. I have put display statements showing elapsed time to execute particular lines of code in one of these functions, but cant see how to progress ths investigation further. What I have found so far:

The code loops around an array with 37 entries in it populating data in an object for each entry. For the first 33 entries the code executes fine, no performance issues. Then it slows right down when executing the db commands. These are all select statements stored in the Access db as queries, and each use a single parameter containing either the primary key of the table being queried, or a foreign key which is indexed. Loads of memory and CPU available, no significant disk activity apparently going on.

My first post on VB Forums and would be grateful for any help as to how to progress this...!