Show size of tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to show the size of the individual tables in an Access database?

It's well published that the maximum database size is 2Gb. Since I'm
approaching this limit I'd like to know the size of each table within the MDB
so I can figure out the best approach for an archiving strategy.

Doug
 
Doug

Maybe I'm missing something...

It sounds like you want to archive your data based on how much room it
takes, not on how central it might be to your overall data model.

One alternative might be to migrate all your data to a bigger bucket ...
have you looked into SQL-Server?

A caution... if you migrate some data out of your current database and into
archives, and if your database is a well-normalized relational database, you
could end up "orphaning" some of your dependent tables' rows. If you
archive by removing data, you'll also need to consider what related data
also has to be archived...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top