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

  • 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