MDB Grows and Grows

[Guest]

I have an Access 2002 MDB that connects to a SQL Server 2000 database. The
MDB is about 9Mb with lots of code. As I work on the MDB it grows.

I have tried various compact-decompile-comact-recompile-comact sequences.
Nothing works. In fact with decompile enlarges it about 10-15%. The only
thing that will ever get it back to size is importing all objects into a new
MDB file.

So that's what I do. Before each MDE deployment, I open a new Access
container, import everything, redo references, etc. Kind of a pain. And the
unchecked growth starts again as soon as I start changing objects. As I
mentioned de-compile makes it worse.

Any ideas? Am I stuck forever having to import to a new container? Thanks
for any ideas.

Tim

 

[Marshall Barton]

I have an Access 2002 MDB that connects to a SQL Server 2000 database. The
MDB is about 9Mb with lots of code. As I work on the MDB it grows.

I have tried various compact-decompile-comact-recompile-comact sequences.
Nothing works. In fact with decompile enlarges it about 10-15%. The only
thing that will ever get it back to size is importing all objects into a new
MDB file.

So that's what I do. Before each MDE deployment, I open a new Access
container, import everything, redo references, etc. Kind of a pain. And the
unchecked growth starts again as soon as I start changing objects. As I
mentioned de-compile makes it worse.

Any ideas? Am I stuck forever having to import to a new container? Thanks
for any ideas.

That problem was fixed in one of the Office XP service
packs. I don't remember which one and I can't find any help
in the OXP KB search, It's got to be in there somewhere, I
just can't seem to be able to wind my way through the UI.

 

[Mark via AccessMonster.com]

You might want to check the options for "Name AutoCorrect". If you have it set to track changes, and have it set to log those changes, your mdb will grow every time you change something because it keeps adding records to a special table.

 

[Guest]

Office update did the job. Thanks!

Tim