Tech Off Thread

1 post

ACE data provider

Back to Forum: Tech Off
  • User profile image
    cheong

    For accessing data with JET, we used to fill the provider with "Microsoft.JET.OLEDB.4.0", and it works great on all WinXP machines.

    With newer version of Windows, Microsoft decided to kill JET on 64-bit side and refuse to port it there. Instead, they tell us to use the new ACE engine.

    That's fine. But now the provider string has changed to "Microsoft.ACE.OLEDB.{MSOffice version}". For example, if you have Access 2007 installed, it would be "12.0". For Access 2010, that would be "14.0". And I still can't find what to specify for Access 2013 (I presume it's "15.0", but who knows?)

    Is there anyway we can define static connectionstring for all versions without having to probe what version of ACE is installed, so that we only have to try connection twice (once for JET, the other for ACE)?

     

    Recent Achievement unlocked: Code Avenger Tier 4/6: You see dead program. A lot!
    Last modified

Comments closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.