Link to home
Start Free TrialLog in
Avatar of Anthony
AnthonyFlag for United States of America

asked on

System locking up when running Access 2007 query

Morning All,

I've encountered this issue before and I don't know how it goes away.  When I run a query in Access against my mainframe system the query appears to lock up.  When it does display the results, it doesn't allow you to click into a cell because it's still running.  It would appear that it's a memory issue on my side but I have 8Gb's of ram in my CPU.  

My query is taking a linked table from my main frame and using a list of ID Numbers from a separate table I've imported from Excel to do a match.  When it finds the match it outputs three additional columns from the mainframe.  Does anyone know why this would happen?

I'm running Windows 7 Professional 64bit, Office 2007, i3 Processor, and 8 gb's of ram.  
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

<I've encountered this issue before and I don't know how it goes away.>
Check your network traffic at the times it runs slow...

Only this one query?
If you delete, then recreate the query, and run it, what happens?

What if you run the query on another machine?

How complex is the "Matching" logic in the query?
How many records are you dealing with?
Geographically, how far away form your machine is the main frame.

What are the network specs?
Avatar of Anthony

ASKER

Yeah I've considered network traffic being an option.

It's not just this one query, it can be others.  I haven't encountered it in a while- but when I do it really bothers me and slows me down.

If I delete and recreate it the same thing happen.

I have to try it on another machine.

The matching logic is extremely simple.  I am just matching two values that are numbers- customer ID numbers.

I'm dealing with about 16,000 records.

I'm about 50 feet from the mainframe.  
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Anthony

ASKER

I'll look into my network connectivity...
Posting the actual SQL here never hurts
Avatar of Anthony

ASKER

It appears that it was my networking connection.  Because my network cable goes into an IP phone first and then to my nic card- that apparently had been the issue.
Avatar of Anthony

ASKER

No, thank you.