M
Matthew Scheperle
I have a question that falls under both Visual Studio and Access 2007.
I have a Forms App that I am creating that will pull data from an Access
2007 database (.mdb format) and manipulate the data to produce reports for
us. There will be no data entry with this app. I can create my DataSet, pul
in the data from the database and display in a datagrid.
However, what I am needing to do now is Pull in the Data from 5 tables and
manipulate it to display my reports. The Access database is set up to run
several queries against one or more tables and produces my reports in Access.
There are some queries that do JOINS between tables on one or more fields. I
want to have my VB.NET app to manipulate this data rather than Access.
What is the best approach for this? I am not looking for detailed code, just
a good way of approaching this and suggestions on websites with sample code
or a good book.
Thanks,
Matt
I have a Forms App that I am creating that will pull data from an Access
2007 database (.mdb format) and manipulate the data to produce reports for
us. There will be no data entry with this app. I can create my DataSet, pul
in the data from the database and display in a datagrid.
However, what I am needing to do now is Pull in the Data from 5 tables and
manipulate it to display my reports. The Access database is set up to run
several queries against one or more tables and produces my reports in Access.
There are some queries that do JOINS between tables on one or more fields. I
want to have my VB.NET app to manipulate this data rather than Access.
What is the best approach for this? I am not looking for detailed code, just
a good way of approaching this and suggestions on websites with sample code
or a good book.
Thanks,
Matt