Database suddenly bloated - Compact and repair has little effect

[frispee]

Hi

I am mid-way through a database system and suddenly today, its size has increased tremendously. It was 12-13 MB till yesterday and today, it is 230 MB. Also, some VBA code is not working as it should be and it is very sluggish. I tried Compact and repair but it only decreased the size by 2-3 MB. I also decompiled it and it had no effect. Please help! :banghead:

 

[Simon_MT]

One is assumming there are no images that have been introduced.

Try a decompile (Access 2007 version):

"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" /decompile

Go into a module and compile.

See if that works.

Another step is to create a new database and import all the objects.

Simon

 

[boblarson]

Also, is this a split database (Backend - tables only, Frontend - everything else)? If not, it should be. And each user should have their own copy of the frontend.