Show size of tables

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
 
J

Jeff Boyce

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find out size of each table 2
Maximum database size - linked tables in a second database 3
Ms Access size? 2
Database Size 2
Difference in size of actual access database and its backup 0
Splitting an Access Database into fe/be-b'cuz db too large 1.65 gi 10
2 gb limit and linked tables 2
Obtaining data from a different access database 6

Top