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...