I have an MDB file created with Microsoft Access 2007. I would like to read the 10 tables from that file. I would like to avoid multiple trips to the database so I would like to get all the data into memory when the for loads. And I will commit any changes when the form is closed.
Can I create 1 DataSet and fill it up with all 10 tables at once or will I need to read each table and create the table in the dataset?
This is ACCDB not MDB sorry.
I now get The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
When I am finished with this project I want to be able to distribute this to multiple computers and I was hoping not to run into component issues.
How can I establish a connection to the Access file that does not require access components to be installed or can I include the components in the install?
I just found this to get rid of the error. I had to switch the build property on the target cpu from any cpu to x86. Anyone have more info on this?
I am using visual studio 2008 in VB.net and its a windows form project.