How many records can an Access table hold

[Julius]

I need to know how many records an access table can hold before trouble
starts. I am looking to populate 2000 records per month, totalling 24000 for
the year. Is the 2000 probably a lot less a month ok. Can someone give me
an answer to this as soon as possible. Oh and please do not tell me the MB
or GIG size I need to know about the record count. Greatly appreciate any
feedback.

 

[Beetle]

There is no record limit, only the total db size limit (which is 2G). However,
Access will handle your 2000 records per month without even
breaking a sweat.

 

[BruceM]

I have heard of tables with over 100 million records. They were very small
records, with only a few fields. Records with many fields or with stored
images can hold comparatively few records. I think the maximum size for a
single record is 2000 bytes.

With a well-designed database several million records should not be a
problem, but without knowing anything about your database there is no way to
say how many records you could store. If you are storing images you could
run out of space in the first year. Excel has a maximum number of rows in a
spreadsheet. There simply is no analogous limit to the number of records in
an Access table.

 

[Jeff Boyce]

Julius

How many people can this elevator hold? (really, now, wouldn't that depend
on how HEAVY they are?)

If your record is 1 byte, your table can hold a lot.

If your record is 2k, that's, hmmm, carry the 7, ... about 50 xx, and Access
can hold up to 2,000 xx, so you can see that you are only using about 2.5%
per year.

If your record is greater than 2k, it won't fit! Access has a size limit on
the total bytes in each record.

You don't mention how MANY tables you are using, nor how many fields. Those
could have an impact, too.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

I need to know how many records an access table can hold before trouble
starts. I am looking to populate 2000 records per month, totalling 24000 for
the year. Is the 2000 probably a lot less a month ok. Can someone give me
an answer to this as soon as possible. Oh and please do not tell me the MB
or GIG size I need to know about the record count. Greatly appreciate any
feedback.

There is no explicit limit on the number of records. 24000 records is small. I
know of working databases with 20,000,000 records in the largest table.
Despite your insistance on ignoring the 2GByte limit... that is the only limit
on table size.

 

[Julius]

You have all been a great help, thank you for your input.