How can I find out how much data is in an Access database?

[gellerche]

Does anyone know if there's a way to see how many Megs of data are in an Access database? I know if you right click on the Access file in Explorer and go to Properties, you can get the size of the database. However, I'd like to find out the size of the data, not including the memory taken up by the structure of the database itself.

Thank you,

Steve Geller

 

[ghudson]

Does size really matter?

Only suggestion I have is to import the data tables into a new db just to see how large the new "data" db is.

Are you compacting your db on a regular basis?

 

[gellerche]

ghudson:

Thanks for your reply. I do compact the database on a regular basis (It autocompacts everytime it's closed). The reason I was asking is that I recently used VB to import a LOT of data from a very convoluted spreadsheet to an Access database. I would like to be able to tell my manager "I figured out how to import x MB of data automatically, and saved the team y (depending on x) days of having to do it manually!"

If it can't be automatically, I will try your suggestion.

Thanks,

Steve Geller

 

[Pat Hartman]

You can get a ballpark number by multiplying the record size by the number of rows in the table. This doesn't consider overhead caused by indexes though.

 

[Sprocket]

If you click on File -- Database Properties -- General tab you can see the file size.

There must be a simple way to reference this value in code, both before and after you import the data

But you can always do it manually for three clicks.