mdb size

[Guest]

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)

 

[Granny Spitz via AccessMonster.com]

How big can one grow too (How many Megabytes)?

2 GB.

When will serious performance
become and issue.

Depends on a lot of factors. A poorly designed database can run into
performance issues at 5 MB when it's subjected to multiple users. On the
other hand a well designed database that has 50 users accessing a 200 MB
database across a network with just select queries probably won't have
performance issues.

How can you tell how many megabytes a table is?

Import it into an empty database and see how big the file grows to be.

 

[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.