Access crashes on exit

  • Thread starter Thread starter Maverick
  • Start date Start date
M

Maverick

What else is there to say. Access is continually crashing when I exit the
application. It wants to send a report then restart Access. Has anyone
experienced this? Is it a known issue (hopefully with a fix)?

Thanks.

---------------------------------------------------
HTH

Don''t forget to rate the post if it was helpful!

My email address is invalid.
Please reply to newsgroup only so that others may benefit.
 
Suggestions:

1. Make sure Compact on Exit is turned off.
In Access 2007: Office Button | Access Options | Current Database
In older versions: Tools | Options.

2. Do you need a service pack?
For Access 2007, the Office 2007 SP1 link is:
http://office.microsoft.com/search/redir.aspx?AssetID=DC102486291033&Origin=HH102511011033&CTT=5
For older versions, see the Office Products list here:
http://support.microsoft.com/sp

3. If that doesn't fix it, do you have anything that is opening another form
when one closes?

4. If you're still stuck, try this recovery sequence that addresses a whole
range of possible issues:
 
Additional responses are inline...

It doesn't crash so much now, but I'm getting the following error when
leaving a record: "The expression On Current you entered as the event
property setting produced the following error: Method or data member not
found." I get the same error for On Unload and On Close. These all worked
fine before this process. It's like working on a car: fix one thing and break
another.
--------------------------------------------

HTH

Don''t forget to rate the post if it was helpful!

Please reply to newsgroup only, so that others may benefit as well.


Allen Browne said:
Suggestions:

1. Make sure Compact on Exit is turned off.
In Access 2007: Office Button | Access Options | Current Database
In older versions: Tools | Options.
Click to expand...

It was turned off. I've read your article on the problems this causes.
2. Do you need a service pack?
For Access 2007, the Office 2007 SP1 link is:
http://office.microsoft.com/search/redir.aspx?AssetID=DC102486291033&Origin=HH102511011033&CTT=5
For older versions, see the Office Products list here:
http://support.microsoft.com/sp
Click to expand...

Already up to date.
3. If that doesn't fix it, do you have anything that is opening another form
when one closes?
Click to expand...

The only form that opens from another form is my custom switchboard. I put
it in a not visible state when other forms are opened and then have the forms
open the switchboard when they close. I exit the database from the
switchboard via a button that runs the Exit Database command.
4. If you're still stuck, try this recovery sequence that addresses a whole
range of possible issues:
Click to expand...

You didn't show a specific recovery sequence, but I did follow your
suggestions from you website. I only have four references running: the three
you recommened and OLE.

The only thing I changed in the process was the Compile on Demand. I
unchecked it as you recommended.
 
I turned Compile on Demand back on and the errors went away. We'll have to
see how the crashing goes. Hopefully it is fixed, but only time will tell.
I'm still getting a really glitchy looking form. I hoped that would go away,
but I still have objects shifting around in Form View and it is often hard to
even read parts of the form. I'm in glitch purgatory.
--------------------------------------------

HTH

Don''t forget to rate the post if it was helpful!

Please reply to newsgroup only, so that others may benefit as well.
 
Ouch! Wouldn't trust that.

You definately need to walk the recovery sequence, turning Name AutoCorrupt
off, decompiling and so on. You may even need the SaveAsText/LoadFromText
steps.
 
Allen,

I just said I went through that process. It was my last inline comment.

Thanks.
--------------------------------------------

HTH

Don''t forget to rate the post if it was helpful!

Please reply to newsgroup only, so that others may benefit as well.
 
As I said earlier, I did all of the steps in the recovery sequence already.
AutoCorrupt is already off (was never on). I had done everything in the
recovery sequence, including unchecking Compile on Demand. However, I had to
turn Compile on Demand back on because I was getting a bunch of errors (noted
in prior post) with it off.

You don't ask much of a guy do you? I'm going on vacation for a week and
will try to tackle the SaveAsText/LoadFromText steps when I get back. There
is a lot to this database (many forms, reports, queries, and lots of code).

I was hoping that this was a known issue with a known fix. Unfortunately,
I'm apparently not so lucky.

Thanks for the guidance. I'll let you know how it turns out. In the mean
time, if you have any other suggestions (i.e. easier to implement), please
let me know.

--------------------------------------------

HTH

Don''t forget to rate the post if it was helpful!

Please reply to newsgroup only, so that others may benefit as well.
 
Back
Top