Bloating?

[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

 

[Sylvain Lafontaine]

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

 

[DS]

Great, Thank you. I was actually looking for this code!
DS

 

[Tom Wickerath]

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
__________________________________________

 

[DS]

Thanks,
I'll read them all. I appreciate it. I'm using Access 2000 format.
DS