Bloating?

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

I usually do a compact and repair on a DB that I am developing. I'm
deleting forms, code and records. When I compact and repair the size goes
down. However when I import my DB into a new clean DB the size goes down a
lot. Why does this happen and why doesn't the size go down this much when I
compact and repair?
Thanks
DS
 
Try using both the /decompile and the /compact options from a shortcut and
repeat the process *two* times:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"C:\MyDatabase.mdb" /decompile /compact
 
Hi DS,

You didn't say what file format that you are working in, for example the
Access 2000 file format versus the Access 2002-2003 file format. Here is a KB
article that you might be interested in looking at:

Database bloat is not stopped by compacting database with Access 2002
format
http://support.microsoft.com/?id=810415

And here are several other KB articles that discuss possible causes of bloat:
http://tinyurl.com/2dmpw


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
Back
Top