Rocky Smolin
rockysmolin at bchacc.com
Sun Sep 12 22:23:17 CDT 2010
Well the report was based on a table - pretty simple. But it had some CBF which was turning a page break on and off and adjusting the Keep Together property in a Group Footer Format event. It was also setting the group level control source in the Open event. I figured out a way to live without all of these things so the report now runs in 2007. Problem not solved, but avoided. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Benson (VBACreations.com) Sent: Sunday, September 12, 2010 7:55 PM To: 'Access Developers discussion and problem solving' Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com