Speed up Do...Loop ending results to a table

[caerdydd]

Hi all
I have some code that performs a Do...Loop that takes a piece of data from a table, finds relevant information from a back end library and then writes it to an output table.
My problem is that as there are 300 different data items the code takes around 10 mins to complete. Is there a way or method to speed this up.
I have not used Access very much so unsure if i can take the whole table as an array i.e count the number of fields stored as an array and then find the results and send it to the output table in one go.
Any thoughts or suggestions much appreciated
Regards

 

[Golom]

Can you post your code?

All you've given us is
[li]Its a Do Loop[/li]
[li]It reads a table[/li]
[li]It looks stuff up[/li]
[li]It loads another table[/li]

That's really not enough to even guess where the bottleneck may be.

[small]On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question. (Charles Babbage)[/small]

 

[addy]

The data it is taking from the table - is this linked at all to the back end library? You say you are finding relevant information from the back end library, how does this work, i.e. if the data you find in your first table also appears in your back end table so that you can identify which is the relevant information, can't you create a query using both tables and pull the info that way?