Writing to Access w/VB.NET

[jpetter7]

Can someone please tell me how to establish a connection to an Access DB from a vb.net form. I have tried to do this from server explorer, but I don't have the option to select MS ACCESS. I get sql server, oracle, and several other options, but Access isnt one of them. Thank you in advance!

 

[levyuk]

You can do this by creating a new OleDbConnection and OleDbCommand fromt he tools menu on the left. Then with the OleDbConnection you will be able to select an Access database. Make sure the database type is set to Microsoft Jet

 

[jpetter7]

Thanks a million! I never would of figured that out... lol. Maybe I can return the favor one day!