CODEWITHSUNDEEP
ms-accesssize
CJ7
CJ7

Reputation: 23285

How to quickly analyse large MDB file

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.

Upvotes: 1

Views: 461

Answers (1)

volody
volody

Reputation: 7189

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

Upvotes: 2

Related Questions