[AccessD] Microsoft Access has stopped working

This happens to me when I am running a union query and something about the
names of fields or potentially the number of fields or one of the field
names in a subquery is not kosher. I have seen Ac2010 be more sensitive than
even earlier versions of Access, which tended to be more liberal for
whatever reason. In other words, Access thinks a query is too complex,
mainly because it is not structured correctly. Perhaps the query plan fails,
I don't know. I used to get messages that the query was too complex at which
point I usually knew the problem was design, not data.

I hate to suggest this because it could be a waste of time if you are
already sure of your queries... BUT ... try unraveling any complex series of
queries and testing each one by one in the design view then data sheet view.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Sunday, September 12, 2010 8:15 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Microsoft Access has stopped working

P.S.  Just converted to a 2007 accdb - same problem. I'm running SP2.  Will
check for updates now.

R


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Sunday, September 12, 2010 5:09 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Microsoft Access has stopped working

Dear List:

I have an app developed in 2003.  Works fine.  When I run it with Access
2007, one of the reports craps out with the cryptic message Microsoft Access
has stopped working (windows is looking for a solution tot he problem - good
luck).

It does it's repair thing but no cigar.

I have no idea where to even being looking.  I don't really want to convert
this app to 2007 because it's a commercial product and I don't know where it
will end up - could be 2003, 2007, or I suppose, 2010.

MTIA

Rocky Smolin

Beach Access Software

858-259-4334

Skype: rocky.smolin

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.com/> 

 

 


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com