Hello,
So I should note before stating my problem that I have been using Access for 2 days now and I don't know much about it at all.
I have a SQL 2008 database on a network drive. It's full of all kinds of tables, and stored procedures. Now I went over to ODBC and linked it in, so I can see all the tables. Then I proceeded to writing a few queries that return tables. Then I went over to report and dragged and dropped the query into the report. My hope was that the report would run that query and return the proper data. If I run the query alone, it works great, but once it's in the report I keep getting a "Select Data Source" window that pops up. I click the tab "Machine Data Source" select my data source name (type is system). Once I click "Ok", the same window immediately pops up again! No matter what I do, I keep getting the same pop up! What could I be doing wrong here?
Thanks,
Allen