Access crashing

[Glenda]

I am using Access 2007 and it is crashing a number of times usually when I
click a button to open a report. There is a time delay and then an error
message saying that Access has encountered an unexpected problem and needs to
close, apologies for the inconvenience.

This didn't happen in Access 2002. My application was created in Access
2002 and is now being used in Access 2007. I have run diagnostics and no
problem was found. I have downloaded the critical updates for Access 2007.

My laptop has 256 MB DDR-Ram and Shared Memory up to 64 MB - could this be a
problem? Could it be Access 2002 features that are changed in Access 2007
but are still said to be supported in Access 2007? Any help/ideas gratefully
received.

 

[GBA]

first step; open the record source for the report...and see what happens.

if it crashes, and is a query; open it in design view and look at the joins
involved...open up any subqueries individually....

 

[Glenda]

Thanks, I'll take a look but I'm not sure that's the problem. One record
source is a union query (SQL) on two tables. Does that make a difference?

 

[Arvin Meyer [MVP]]

I am using Access 2007 and it is crashing a number of times usually when I
click a button to open a report. There is a time delay and then an error
message saying that Access has encountered an unexpected problem and needs
to
close, apologies for the inconvenience.

This didn't happen in Access 2002. My application was created in Access
2002 and is now being used in Access 2007. I have run diagnostics and no
problem was found. I have downloaded the critical updates for Access
2007.

My laptop has 256 MB DDR-Ram and Shared Memory up to 64 MB - could this be
a
problem? Could it be Access 2002 features that are changed in Access 2007
but are still said to be supported in Access 2007? Any help/ideas
gratefully
received.

Yes, 256 MB is not enough to run Office 2007. Nowhere near enough actually.
My slowest machine running Access 2007 has 2 GB of DDR2 RAM, but you could
do it with a single GB. I don't think that's your problem though, although
it may have contributed to the underlying cause. I would guess that you have
a corrupt object. It could be the button, the form it's on, or the report.
ALWAYS WORK ON A COPY WHEN WORKING WITH CORRUPTION. Try opening the report
directly from the Navigation Pane. It may be a slight corruption which is
fixed by decompiling and recompiling in Access 2007. Here's some other
corruption tips:

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Decompile your database:
http://www.trigeminal.com/usenet/usenet004.asp

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com

 

[Glenda]

Thanks Arvin. The record source is a union query. I changed it from * to
listing all the fields with criteria and it didn't crash. I removed the
criteria and it didn't crash. I removed the field names and put the * back
and it didn't crash! Seems to be temperamental.

I'm wondering if your suggestion of a corrupt button etc is the issue but
wouldn't that make it crash each time?

 

[Arvin Meyer [MVP]]

None of those actions should have caused or solved the problem. What could
have happened, however, is that the query compilation was corrupt, and by
changing the query it decompiled and was recompiled when run again.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Glenda]

Thanks very much Arvin. Hasn't crashed since so far!

 

[Tony Toews [MVP]]

I am using Access 2007 and it is crashing a number of times usually when I
click a button to open a report.

Try using a different default printer. Or install a PDF printer
driver and set that to the default and see if that fixes the problem.

PDFCreator is a free, open source tool for creating PDF files.
http://sourceforge.net/projects/pdfcreator/ Watch out for the $$$
software with the same name.

Tony