Data Source problem

[Deki]

I created passthorugh query and Data Source for it for one report. It is
working great for first report, but when I created second report, passthrough
query and Data Source, Select Data Source window keeps on poping-up every
second
unless I change record sorce to something else then that passthrough query.
Also, it prompts user to select record source 4 times when report is called.
I searched everywhere, but no answer. I even tried to recreate SQL database
and whole Access part on different machine, but no luck. Please help!

 

[Ofer Cohen]

In the new query, did you specify the ODBC Connection?
Open the query in design view, open the query roperties (in the menu bar
select view > properties), locate the cursor in the property, set the ODBC
connection by pressing the button with the three dots.

 

[Deki]

That was it! I spent 2 days trying to figure it out! Thank you, thank you,
thank you!
--
Deki PA

In the new query, did you specify the ODBC Connection?
Open the query in design view, open the query roperties (in the menu bar
select view > properties), locate the cursor in the property, set the ODBC
connection by pressing the button with the three dots.

 

[Ofer Cohen]

Your welcome, Your welcome, Your welcome
Glad I could help
--
Good Luck
BS"D

That was it! I spent 2 days trying to figure it out! Thank you, thank you,
thank you!