How to determine size of internal DB components

[deduct]

I have been given an Access 2000 database. It is 32MB in size. I know little about the database except that almost all of the tables are empty and the ones containing data have only a few records. I have run the "compact and repair" and that did not reduce the size at all. My question is - how can I quickly see the relative size of the various tables, queries, reports, macros, and modules? Perhaps the file should be this big, but I would like to see where the space is being used. Karl

 

[deduct]

I have tried to search this site, but perhaps I am not using the right terminology. I tried searching for "access size components". Any other suggestions? Karl

 

[Rick39]

Maybe the simplest way is just to create a new blank database and begin importing the objects to see the relative size increases

 

[deduct]

Thanks, that is an idea, but there are quite a lot of queries, tables, forms, etc., so this method would take quite a while. But that is what I will do if I can't find some automated way. Karl

 

[Rick39]

The reason I mention it was because I had to do the same thing last week for a database that ballooned from about 20 to 66M.......I imported groups of objects at a time.....turned out there was some corrupt modules behind forms and service release issues