asked on 5/1/2006

Pass Through SQL Query

Experts:

I get a ODBC Timed Out Error when I try to run a SQL Query in Access.

What is the correct way to setup / run a SQL Query in ACCESS so as just to use Access as the application to pull the data. I'm wanting the results of the query in Excel. I'm dialing in via CITRIX and the SERVER that Citrix resides does not have my normal Crystal Reports XI or SQL Query Analyzer loaded on it. It does however have ACCESS loaded and so I'm just trying to use ACCESS to run the SQL for me.

thanks
m

Microsoft Access

Last Comment

Marcus Aurelius

5/5/2006

napel25

5/2/2006

It's quite straitforward to setup a pass through query. You probably already did that right, because otherwise you didn't get a time out error. I think you can try to rise the timeout period.
But you probably better look at network things like firewalls and protocols.

Marcus Aurelius

5/2/2006

ASKER

Nape:

I am NOT an Access person, I'm a Crystal Reports Expert...and so... how do I set the DB in Access? I'm not sure 'how' access knows to connect to the db? Is it the SQL Statement that handles the "CONNECTION?"

ASKER CERTIFIED SOLUTION

napel25

5/3/2006

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Marcus Aurelius

5/5/2006

ASKER

Nape...thanks for your help.
M