 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / July 2006Data Source problem
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!  SignatureDeki PA -- 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. SignatureGood Luck BS"D > 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 [quoted text clipped - 4 lines] > 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! That was it! I spent 2 days trying to figure it out! Thank you, thank you, thank you! SignatureDeki 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 [quoted text clipped - 9 lines] > > 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! Your welcome, Your welcome, Your welcome Glad I could help SignatureGood Luck BS"D > That was it! I spent 2 days trying to figure it out! Thank you, thank you, > thank you! [quoted text clipped - 12 lines] > > > 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! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.