Answered by:
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 !
Friday, May 14, 2010 6:47 PM
Answers
-
User1045943723 posted
Have you tried looking here?
http://www.connectionstrings.com/access
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Friday, May 14, 2010 7:06 PM -
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?
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Saturday, May 15, 2010 8:27 AM
All replies
-
User1045943723 posted
Have you tried looking here?
http://www.connectionstrings.com/access
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Friday, May 14, 2010 7:06 PM -
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?
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Saturday, May 15, 2010 8:27 AM