<div>
Thanks OM Gang.<br />
I have Access97 and the command qdf.RefreshLink is not valid.<br />
Any thoughts?<br />
Thanks!
</div>


Thanks OM Gang.
I have Access97 and the command qdf.RefreshLink is not valid.
Any thoughts?
Thanks!

<div>
Try qdf.Refresh<br />
Let me know if it still doesn't work.<br />
OM Gang
</div>


Try qdf.Refresh
Let me know if it still doesn't work.
OM Gang

<div>
There is no QueryDef.Refresh<br />
<br />
however, <br />
<br />
QueryDefs.Refresh is valid.<br />
<br />
:)
</div>


There is no QueryDef.Refresh

however,

QueryDefs.Refresh is valid.

:)

<div>
Does CurrentDb.QueryDefs.Refres<wbr />h successfully update the connection string for the pass-through query?<br />
OM Gang
</div>


Does CurrentDb.QueryDefs.Refresh successfully update the connection string for the pass-through query?
OM Gang

<div>
Yes!! That's it!!<br />
<br />
Perfect...thanks!!<br />
<br />
Cheers,<br />
Russ :)
</div>


Yes!! That's it!!

Perfect...thanks!!

Cheers,
Russ :)

<div>
I tried it in Access 2007 and it works - the pass-through connection string is updated.<br />
OM Gang
</div>


I tried it in Access 2007 and it works - the pass-through connection string is updated.
OM Gang

<div>
You're welcome.<br />
OM Gang
</div>


<div>
<div class="content wysiwyg-content">
I wish to use a pass-through-query in Access97 to speed up retrieving a recordset from an SQL server.<br />
<br />
I can setup the parameters for the ODBC Connection String by opening up Properties for the pass-through-query in Access97.<br />
<br />
Question is, how do I open the pass-through-query and programatically supply the ODBC Connection String needed to connect to the SQL server?<br />
<br />
High points for a speedy answer!
</div>
</div>


I wish to use a pass-through-query in Access97 to speed up retrieving a recordset from an SQL server.

I can setup the parameters for the ODBC Connection String by opening up Properties for the pass-through-query in Access97.

Question is, how do I open the pass-through-query and programatically supply the ODBC Connection String needed to connect to the SQL server?

High points for a speedy answer!

Access97 Pass-through-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.