Maximum records or table size allowed in access

[hnunez4399]

Is there a maximum number of records or size that is allowed for a table in access?
Is there a point where it where no longer accept anymore records?

Is there a way to see the current size of a specific table?

Thanks in advanced.

 

[rjoubert]

Here's a post that talks about the max limits of Access...

http://www.programmingtalk.com/archive/index.php/t-28980.html

Good Luck!

 

[Golom]

Limits on Access tables are in terms of the total size (in bytes) of the table ... not on a record count. In Access 2K or above, the limit is 2 GB for the whole database and 1 GB for a single table.

You can easily determine the number of records in a table but the record size in bytes is more difficult because things like text strings will vary in size depending on the actual data stored in them. Further, objects like memo fields or images are not stored "in" the table but are stored elsewhere in the MDB and only a pointer to them exists "in" the table.