size of objects

  • Thread starter Thread starter simeon
  • Start date Start date
S

simeon

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

thank you in advance
 
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***
 
Back
Top