>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 agree with Eric and J.Crescencio Flores. My advice would be not to forget to compact MDBs on regular basis. In your case it could be even daily. And make sure you don't have indexes you don't use, because indexes also take space in MDB file.
HTH
Igor Gelin
Database Developer