Problem with Access Crashing with no Error

[Eric Heinold]

I have a database created in Access 2000. I have all the latest sevice
packs installed for Window Xp, and Access. On my computer I have Access 97,
Access 2000, and Access XP installed.

When testing my application, I will often get Access abruptly exiting with
no warnings. The window just disappears. Restarting does not indicate that
anything went wrong. I have never been able to duplicate getting it to
crash. It happens in different spots everytime, and after working for
different lengths of time. I have spent quite a bit of time tyring to pin
down a pattern, but have not been able to do so. Sometimes it happens when
opening a form, other times immediately after entering data (the data does
get saved).

I looked in the knowledge base, but the only thing I found relating to it,
says the removing the check for Track Name Autocorrect, will stop the
behavior. However, I have already turned this off (and I have imported all
my objects into a new database, just to test it.)

This happens on many of the computers that the database resides on so I do
not think it would be hardware related. The computer configurations vary
widely.

There in nothing in the event logs that show up when the program disappears.

What other things might be causing this?

Thanks,

Eric Heinold

 

[Guest]

It certainly sounds like a corruption issue. Try importing all the tables,
queries, etc., into a new mdb file. If something refuse to import, it's
corrupt.

I've also seen this behavior with corrupt data in a memo field. If you don't
have too many records, open the table(s) with memo fields and go to that
field. Hold down the down arrow key to move through the records. If the
database shuts down, you hit a corrupt memo field in a record. If this
happens I have a paper on fixing corrupt databases towards the bottom of the
page below. Paragraph 6 explains how to save almost all of your data:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Whittle,Jerry

 

[Eric Heinold]

Forgot to mention that. I have tried importing everything from one database
to another. That seemed to help a little, but it is definitely still
crashing.

 

[Harlan.Koehn]

Check to make sure you didn't use this VBA code as a saverecord
command.

DoCmd.Save

This code was crashing my application.

Use DoCmd.RunCommand acCmdSaveRecord instead.

 

[Tony Toews]

When testing my application, I will often get Access abruptly exiting with
no warnings.

This is interesting. I read in another posting you've tried
importing. Have you tried decompiling?

Decompile or how to reduce Microsoft Access MDB/MDE size and decrease
start-up times
http://www.granite.ab.ca/access/decompile.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm