compacting access database does not remove all temporary files

K

Ken Jerrard

After compaction my database size is reduced but not correctly.

I have copied the daid DB to a new DB, deleted all the tables, forms etc.
and created a new small system. After compaction the size is close to 38Mb
(the original DB size was 70Mb).

How do I get rid of all the unnecessary temporary staff?
 
A

Allen Browne

Recreating the database is a fine way to get rid of the spurious stuff.

It might also help to turn off Name AutoCorrect under:
Tools | Options | General
More info on that:
http://allenbrowne.com/bug-03.html

A Decompile might also help. Enter something like this at the command prompt
while Access is not running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

Then compact again.
 
Top