UNION / UNION ALL Query Crashed Access (1 Viewer)

L

LB79

Registered User.

Local time

Today, 06:20

Joined

Oct 26, 2007

Messages

505

• Oct 24, 2013

• #1

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

 

MSAccessRookie

AWF VIP

Local time

Today, 01:20

Joined

May 2, 2008

Messages

3,428

• Oct 28, 2013

• #2

I am not an expert in this area, but you can check the following Link to see whether other experts that have encountered similar issues can be of help to you.

-- Rookie


http://answers.microsoft.com/en-us/...crashing/4f06467f-791e-4d38-b47a-ffc0483fa375

 

T

taifoor

Registered User.

Local time

Today, 09:20

Joined

Jul 16, 2015

Messages

62

• Jun 9, 2017

• #3

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.

 

apr pillai

AWF VIP

Local time

Today, 10:50

Joined

Jan 20, 2005

Messages

735

• Jun 11, 2017

• #4

Few things to know about Union queries:http://msaccess-tips.blogspot.com/2008/02/union-query.html

 

Last edited: May 8, 2018