Getting Data from an Access mdb from within VB.NET application.

[Sigma248]

Hi All,

How would I open up a connection to an Access mdb from within VB.NET to allow getting data from tables.

 

[MarkK]

There are a bunch of ways. Check out the Sytem.Data.OleDb Namespace, which provides Commands, Connections, Readers, DataAdapters, and much more.
- Or in .NET 2.0 read up on TableAdapters and AccessTableAdapters.
- Or set a reference to DAO.
- Or set a reference to ADO

 

[Banana]

I personally wouldn't bother with referencing ADO or DAO. Using either library in .NET can be quite foreign due to those libraries being COM and there are lots of differences between a COM object and a .NET object. I'd just use the OleDb Namespace; AccessTableAdapters sounds good, too.