UNION / UNION ALL Query Crashed Access

LB79

Registered User.
Local time
Today, 23:42
Joined
Oct 26, 2007
Messages
505
Hi all,

I'm having a problem with a UNION / UNION ALL query.
It seems there is a application crash fault when running the query that MS are aware of and have issued a hot fix.
Unfortunately it will take my IT dept some time to check and install the hot fix – If they agree to do it at all.

I wondered if anyone else had this problem and knew of another way around it?

Many thanks

Problem signature:
Problem Event Name: APPCRASH
Application Name: MSACCESS.EXE
Application Version: 12.0.6606.1000
Application Timestamp: 4e27ab6b
Fault Module Name: ACECORE.DLL
Fault Module Version: 12.0.6607.1000
Fault Module Timestamp: 4e379959
Exception Code: c0000005
Exception Offset: 000d7aa3
OS Version: 6.1.7601.2.1.0.16.7
Locale ID: 2057

Additional information about the problem:
LCID: 1033
Brand: Office12Crash
 
Union queries seems to be very heavy for ms access to handle. for workaround, i one time created local table from source qry. Then on activate event of form/report, i used delete all data in that local tabel qry run and appendng union qry data in local table. and made the local table source of form/report. This will not put load on ms access.
 

Users who are viewing this thread

Back
Top Bottom