What is the record limit of an Access table, before it becomes too sluggish to use, and what suggestions are there on how to deal with this issue?
I am appending around 2500 records a day, and am afraid it will grow to a table that is un-useable in a short time.