Can't see my MS Access Query in Visual Studio
Posted on 2009-04-19
I have a windows application that is written in Visual Basic .NET in Visual Studio. I created a query in MS Access that joins multiple tables and queries. At one point I was able to add the query to my dataset. I used the query as a basis for a report.
I had to make a change to the query so I went into MS Access and modified the query to include another field. When I went back into Visual Studio, the dataset did not reflect the change in the query. I couldn't find a way to refresh the query. I went to Server Explore and did a refresh on the database. Under Views I looked for the query but it is not displayed. Other queries are. I deleted the query from my Dataset before I did the refresh and now I can't get the query back. Since the query is gone I now get an error when I compile because my report is still looking for the query. Any idea how I can get my dataset to see the query from ms access?
I appreciate any help on this since I am under a deadline to get this project delivered.