Sql Union All Query in Access Issue

[mmgummy]

Hello, Hoping someone can help. In Access 2010, I created a SQL Union All query. It runs within seconds on my computer and 3 other of my co-workers computer.... with no problem. However, there are 2 computers that is doesn't work on. The query just keeps spinning, becomes non responsive and never completes. Does anyone know why this is happening?

 

[isladogs]

Welcome to AWF

You need to identify what's different about those 2 computers

The usual suggestion when something works on one computer but not another is to check for missing references.

 

[jleach]

Are those other two computers using a wireless connection by chance, or accessing the backend over a WAN as opposed to a LAN? Is this an Access backend or are you connecting to SQL Server or some other database?

Long running queries can throw Access into a non-responsive state, and - depending on how bad it is - can take hours to run, but they eventually will complete. Thus, I'm not sure about "never completes" or is it "takes a really really long time to complete"

If there's an error of some sort, Ridders suggestion would be my starting point. If it just takes forever but no real error, it could just be a slow connection.

Do you call any VBA code in your query? If so, try putting a static counter in there and debugging out to the immediate window the current count for each time the procedure is hit. That should open up some insight as to whether it's completely hanging or whether it's just excruciatingly slow (don't forget a DoEvents so the immediate window has time to refresh between calls, otherwise it'll look like nothing's happening)

 

[mmgummy]

Thank you both for your replies. I am going to check out the SharePoint connections on those 2 computers as well as the slow connections. Greatly appreciate your help!