How to quickly analyse large MDB file

Question

I need to know how to quickly analyse a large MDB file (about 1GB) to see which tables are causing it to be so big. Is there something that will easily allow me to show a breakdown of which tables are responsible for how much data.

Answer 1

One of possible scenarios is that mdb file needs to be compacted

You can use vbscript for that, just set correct file paths

' For Access 2000, use Application.9
'Set objAccess = CreateObject("Access.Application.9")

' Perform the DB Compact into the new mdb file
' (If there is a problem, then the original mdb is preserved)
objAccess.DbEngine.CompactDatabase strPathToMDB ,strCompactedDB