Thanks Gavin,
>Have you tried opening the tables exclusively? Replaces, Inserts, Appends, Etc run faster when the table is opened exclusively.
I have used both tables exclusively as soon as I start the program
If all else fails, I will right something that will run the program at 6:30 in the morning so by 8:00 it would have already run
What is Wisdom?
Wisdom - The ability to respond to any situation according to God's Plan.
Therefore:
USE Wisdom IN Everything ORDER priority AS Knowledge
SELECT Knowledge
BROWSE FOR Understanding WHERE Wisdom=Guide
LeRoy Jackson