mdb size

[Dave]

How big can one grow too (How many Megabytes)? When will serious performance
become and issue.

How can you tell how many megabytes a table is?

 

[Douglas J. Steele]

In Access 97 or earlier, an MDB file cannot exceed 1 Gb. In Access 2000 or
later, it can't exceed 2 Gb.

There's no easy way to determine how much a particular table is taking
(other than compacting the database, noting the size, deleting the table,
compacting the database and noting the size again)

 

[Arvin Meyer [MVP]]

How big can one grow too (How many Megabytes)? When will serious
performance
become and issue.

Theoretically, according to the specifications, 2G for all databases from
Access 2000 on, and 1 GB before then. (Access 1.0 was 100 MB) With correct
design, a reasonable number of users, and a quality network, I doubt if
performance will ever become a problem.

How can you tell how many megabytes a table is?

You can calculate the size it should be by adding the fieldsize properties
up. If you really need a specific table's size, one trick I use is to make a
copy and compact it several times. Make a note of the file size. Delete the
table and compact it several times again. The difference will be the tables
size including the design and index overhead.