Pass Thru Query

[Guest]

Hi All,
I am converting an Access 2003 Reporting system to SQL 2000. My tables that
I have been running all these access reports from are getting too large and
are choking Access. I am keeping the report portions of all my macros, but I
am converting all the queries to Stored Procedures in SQL 2000. I am
creating pass thru queries for these so the look and feel are the same as
they were in Access only much quicker with out all the timeout errors.

My question is, how do I programmatically tell Access what my ODBC
connection is? Every time it invokes a Pass Thru query it asks for the ODBC
connection.
My users do not like to have to pick it every time they run a report.

TIA,
Joe

 

[Guest]

Hi Joe,

After you have defined the Access query as a pass-thru, open the query
properties and click in the "ODBC Connect Str" field. If you already have
the connect string, you can paste it there, or if not, you can click the
button to the right to build the string. Either way, the string will get
saved with the query so you shouldn't have to enter it again.

HTH, Ted Allen

 

[Guest]

Thank you Ted!!!!

Joe

 

[Guest]

My pleasure, glad it helped.