VB.net 2010 - backend database Access but later SQL
Posted on 2011-05-04
I am building an Excel 2007 Workbook application in Visual Studio 2010.
I am going to start with an Access backend and then at some later
point change this to SQL. Because of this I want to maintain flexibility on the
connection to the database, and not use strongly typed datasets yet. I recently had a VB.net we app where I used a connection string as follows. Is this the best sort of approach?
How would I go about this?
<add name="WhatEverNameYouWant" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|PWeb.accdb;" />