find out size of each table

  • 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
 
Answered in response to one of your posts in another newsgroup.

It is rarely necessary to post to more than one group ... but if you feel it
is, posting separate questions to each 'group means you (and we) have to
look at all the groups to find all the responses. If you post once, to all
relevant groups, an answer in one shows up in all.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Is there a way to show the size of the individual tables in an Access database?
Click to expand...

? CurrentProject.Connection.OpenSchema(adSchemaStatistics).GetString

Jamie.

--
 
Back
Top