How do get my ado.net to read a accdb database

Question

User-49466106 posted

 Hi;

I am I the process of converting several *.mdb Access 2003 files to Access 2007.

I was able to connect to the mdbs I changed the connection string file name part to mydata.accdb

but the oledb provider isn't equipped to deal with this file i.e. Unrecognized database format.

I  downloaded and installed  the Access 2007 engine so how do I associate it with ado.net ?

Here is my connectionstring : 

connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDictionary|aNew2007File.accdb;" providerName="System.OleDB"/

Thanks for your help !

 

Answer 1

User1045943723 posted

Have you tried looking  here?

http://www.connectionstrings.com/access

Answer 2

User-1199946673 posted

I am I the process of converting several *.mdb Access 2003 files to Access 2007.

 

Waht is the goal of this conversion? In a web environment, there's no significant performance improvement when using accdb files over mdb files.

Regarding you connectionstring, it looks could to me. Other than performance, I can't imagine why you want to convert anyway? Why don't you just use mdb files anyway?