Access 2000 shutdown during save operation

[Guest]

I'm having a problem with Access 2000 shutting down when I click on the save
button after editing some of the form code. Doesn't happen all of the time,
but often enough to be irritating (imagine that)...especially if I haven't
successfully saved a few minutes earlier.

Of course, none of the changes were saved and there are no error messages.
The program just disappears.

Has any one else seen this and know what's going on? I'm trying to avoid the
99$ min. cost for Microsoft help and would like to stop having to remember to
save every couple of minutes to reduce the amount of data lost.

 

[Allen Browne]

Sernion, are you editing in break mode? (i.e. while the code is executing?)
If so, you might want to see if avoiding that makes a difference.

Also, from the code window, choose Options on the Tools menu. Make sure
Compile On Demand is turned off.

Thirdly, uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html
Then compact the database:
Tools | Database Utilities | Compact/Repair

The other thing that may help is a decompile. 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"
Then open Access (holding down the Shift key if you have any startup code),
and compact again.

We are assuming here that you have SP3 for Access 2000, and SP8 for JET 4.
Help | About shows you your service pack and you can download updates from:
http://support.microsoft.com/sp
(The JET 4 update is under Developer Tools.)

For other suggestions to prevent corruption during development, see:
http://allenbrowne.com/ser-25.html