The Jet database engine (not Access itself) has a file size limit (2
gigabytes for an mdb file), so its just a matter of how many records it
takes to get to that point.
My guess is that 5k records is miniscule (no offense intended) and that you
have nothing to worry about, but if you find yourself flirting with 2gb
files, its especially important to make sure you are compacting regularly.
If you're adding at this rate, you'll need to start getting concerned in about
2206, even without updates to the software or hardware. Access can handle into
the millions of records, given appropriate design and proper care of the
database.
John W. Vinson [MVP]
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.