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

I don't know the physical limit but a work around can be to partition your table horizontally. This means to stock your data on many tables based on a criteria. For example, you could partition your data by year (2500 records * 250 days = 625 000 records/year).