<div>
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. <br />
But you probably better look at network things like firewalls and protocols.
</div>


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.

<div>
Nape:<br />
<br />
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 &quot;CONNECTION?&quot;
</div>


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?"

<div>
Nape...thanks for &nbsp;your help.<br />
M
</div>


<div>
<div class="content wysiwyg-content">
Experts:<br />
<br />
I get a ODBC Timed Out Error when I try to run a SQL Query in Access. <br />
<br />
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 &nbsp;use ACCESS to run the SQL for me.<br />
<br />
thanks<br />
m
</div>
</div>


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

Pass Through SQL Query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.