Access 2007 crashes but Access 2002 - 2003 runs dynamic crosstab q

[Gerard]

I have converted an application from 2003 to 2007. Several dynamic crosstab
queries crash Access and make back up files and leave a log in event viewer
event id1000 which has no meaningful answer. I can get the reports to run in
A2007 if they are in design view then select report preview. If I run from
the design tab they crash, the same applies when running as full app. Each
segement of code seems to run ok if you force variables etc. debug appears to
no help
Can somebidy give me some clues how to debug this type of error
Gerard

 

[Allen Browne]

Gerard, there was a bug like this in the original release of A2007 that was
fixed in Service Pack 1. If you don't yet have SP1 for Office 2007, grab it
from:
http://office.microsoft.com/search/redir.aspx?AssetID=DC102486291033&Origin=HH102511011033&CTT=5

More on the bugs, services packs, hotfixes, and other compatibility info:
http://allenbrowne.com/Access2007.html#Bugs

 

[Duane Hookom]

There is more than one solution for creating dynamic crosstab query reports.
It might help us if we knew which method you chose.

 

[Gerard]

Yoy are right I installeds Sp1 and my problems disappeared
I had the machine auto updating but it appears I missed SP1
Thanks
Gerard