Search code examples
databasevisual-studio-2010ms-accessread-write

Reading From/Writing To an Access Database in VB.Net 2010

I have been working on this for a few days now and I have checked two or three books I have laying around for VB.Net 2003 and the method to do this has changed. Also, I have searched this website for other answers to the same, and found a reference to the MSDN that said something about a ConnectionString. I could not find decent documentation on the ConnectionString, and the rest of the method given was useless without it, so now I must ask... How can I read and write to and from an Access database file in VB.Net 2010?

Solution

  • Carl Prothman has lists of connections strings for just about every occasion:

    http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForMicrosoftJet

    http://www.connectionstrings.com/access

    Access has two versions, ACE and Jet.