Number of records

[Gus Chuch]

Does access have a maximum number of records a table can have?
One of my tables has two years of data and it’s up to 5000 records now.

 

[Jeff Boyce]

Gus

Access has a maximum size for the .mdb file your table(s) are inside. The
max depends on the version.

A table might have 5 fields or 200 fields (hopefully NOT the latter).

5000 rows, however, unless there are a LOT of fields, is not that many.

I've used Access databases with a half-million rows...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[George Nicholson]

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.

 

[John W. Vinson]

Does access have a maximum number of records a table can have?
One of my tables has two years of data and it’s up to 5000 records now.

<chuckle>

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]