MDB Grows and Grows

[Tim]

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.

 

[Tim]

Office update did the job. Thanks!

Tim