Replies

Interesting. The Access 2000 Help File still indicates a 1 gigabyte single table size limit.

Btw, is the Access 2 gigabyte limit an Access constraint, or is it tied to FAT32? If the latter, will be seeing a much larger file limit as everybody moves to NTFS?

Thanks again.

Interesting. The Access 2000 Help File still indicates a 1 gigabyte single table size limit.

Btw, is the Access 2 gigabyte limit an Access constraint, or is it tied to FAT32? If the latter, will be seeing a much larger file limit as everybody moves to NTFS?

Thanks again.

We use Access as a front end with SQL Server as a backend for large database applications. When we’re using Access to prototype an application, we’re often given many very large tables. If we need to create several mdb files to get around the 2 gigabyte mdb limit, we want to know how large each table is so we can combine them rationally in new mdb files. Also, append queries can increase an existing table beyond the 1 gigabyte table limit. Again, we’d like to know when a given table begins getting large enough for us to be concerned about possibly exceeding the 1 gigabyte limit as we add new records.

Thanks for your response and interest.

We use Access as a front end with SQL Server as a backend for large database applications. When we’re using Access to prototype an application, we’re often given many very large tables. If we need to create several mdb files to get around the 2 gigabyte mdb limit, we want to know how large each table is so we can combine them rationally in new mdb files. Also, append queries can increase an existing table beyond the 1 gigabyte table limit. Again, we’d like to know when a given table begins getting large enough for us to be concerned about possibly exceeding the 1 gigabyte limit as we add new records.

Thanks for your response and interest.

(Edited by HansV to make subject a bit more descriptive than “Access”)

How do you get the size (megabytes) of a table?