"spinning" db when I save

[richardconers]

I have a AccessXP db , about 50MB size (no internal tables, only tables
used are linked from another db). the forms are complicated and
there's lots of VBA. Recently, whenever i make the smallest change,
even though I've previously compacted the db numerous times, it goes
into "spin" mode when i try to save it (the screen goes white, windows
task manager shows all access windows as "not responding", etc.) and
this goes on for 3 or 4 minutes, and sometimes, it does not stop until
I have to terminate the program. Sometimes, just adding a blank line
to a module in vba sends the db into spin mode. Anything that can be
done about this?
Thanks!!!

 

[Allen Browne]

A decompile might help.

Try this sequence (in order):

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html
Try unchecking the Windows in Taskbar option as well.

2. Close the VBA window, and then compact the database:
Tools | Database Utilities | Compact/Repair

3. Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Open Access (holding down the Shift key if you have any startup code),
and compact again.

5. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

6. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.