size of objects

S

simeon

how can i see the space in the hard disk that consumed by
every database object?

thank you in advance
 
S

Scott Shearer

If you are referring to Access databases, you can do a search within Explorer for all files with a .mdb, .mde, .adp, .ade, .mda or .mdw extension ( I think thats all of them). When explorer shows you everthing it finds with those file extensions, highlight/select them all, right click and select properties. The properties window will show you the combined size of the files you highlight.

If you aren't doing anything fancy, then just worry about .mdb files (the actual database) and .mda/.mdw (security) files.

Scott Shearer, MCSD, MCDBA
****msshearer@@@hotmail.com***
 

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

Top