Pass-Through Query

[Will]

What is the correct wording for a pass-through query so
you don't have to have the annoying Select Data Source
Window pop-up? I am executing a Stored Procedure on my SQL
server and would like to just open a form with a cmd
button that executes the procedure. I have the form, and
did the button, now all I need to do is update the query
so it wont have the window pop-up.

Thanks

Will

 

[Van T. Dinh]

Which Pop-up window?

Have you set the ODBC Connection String for your Pass-
Through Query?

It is a necessary Property for PTQ. You can see this
Property in the Properties window for the PTQ.

HTH
Van T. Dinh
MVP (Access)

 

[Will]

I found it, I had to set the ODBC connection in the
properties of the query.

Learn something new every day.

 

[Van T. Dinh]

That's what I wrote in my previous reply!

Did you read it before your 1st reply to my post? <grin>

 

[Will]

Yep, I read it, just didn't know where to set it. Been
almost 3 years since I had to create an Access Database.

Thanks for getting me on the right track. SP's are
working, and turned off the anoying warning boxes. Runs
completly in the background. Pretty fast to, considering
the SP is on a SQL box in St. Lous, that pulls data from
an Oracle DB in Dallas.

Thnaks again,

Will