Search results

Think of it as a fresh model everytime it runs. I'm not trying to reduce the number of records processed at this point I'm just looking for guidance on the most efficient way to process them.

Thank you for the responses, I'll agree it is a bit strange... it is a .mdb file... the data is definitley normalized hence the need to pull information from table c for processing. This is something that would be run periodically by a user in order to test the impact of changes made to Table C...

I have 4.2 Million records in a table that I need to process through 1 record at a time. I will only need to move forward through the records one time and perform calculations on and update each record. Using Access 2003 all tables are native Access. Can I or should I process all records and...