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.