I'm hoping someone may have some ideas as to why the following keeps happening when I try to build and run queries in Access 2007.
I'm using linked Oracle tables and am pulling under 200k records.
Four tables joined with just a couple of IIf statements and criteria.
Each time I run my query, no matter how many records it is supposed to pull based on the criteria I enter, I end up having to alt-ctl-del to get out of Access as it completely locks up on me.
I am also trying to create a query based off my main query and joining a crosstab query with it. In the query design grid, I drop my main query, then, when I go "show tables" and try to add the crosstab query to the grid, it locks up on me again.
Not sure how much info is needed, but I have a Dell with a 1.66 ghz processor, 3 GB RAM and am linking to the Oracle tables through a network.
The same thing is happening to me when I try to pull data into Excel from Access.
Could this be my system performance, network? Does 2007 have some speed issues? I would appreciate any help or point in the right direction.
Thanks