locked
Is there documentation for Microsoft.ACE.OLEDB.12.0? RRS feed

  • Question

  • Many questions have been asked and answered about the Microsoft.ACE.OLEDB.12.0 provider. But I simply cannot find solid, official documentation on it. How is one supposed to know which connect string arguments are available? For example, below is the clear, thorough documentation on the old Microsoft.Jet.Oledb.4.0 provider:

    http://msdn.microsoft.com/en-us/library/ms681754(v=VS.85).aspx

    Does anyone know where something like this can be found for Microsoft.ACE.OLEDB.12.0? Right now I'm using it to connect to MS Access 2007+ databases (.accdb.)

    Thanks,

    jmh

     


    jmh
    • Moved by 许阳(无锡) Thursday, February 24, 2011 2:39 AM ADO.NET related (From:General Office Development)
    Wednesday, February 23, 2011 8:56 PM

Answers

  • So thats actually a "No" then, there is no official documentation available.

     

    Shame the mod decided their own answer was good enough and marked it as answered (as appears to be the norm - I suppose it makes their stats look good)!

    • Proposed as answer by Dougbo Thursday, July 21, 2011 3:40 AM
    • Marked as answer by Joshua Honig Wednesday, July 27, 2011 1:10 PM
    Thursday, May 5, 2011 2:22 PM

All replies

  • Hello jmh,

     

    Welcome to the MSDN Forum and thanks for posting here.

    As I know, there is an article talking about Microsoft.ACE.OLEDB.12.0, it may help you. Here is the link:

    http://blogs.msdn.com/b/farukcelik/archive/2010/06/04/accessing-excel-files-on-a-x64-machine.aspx

    And a thread is a good example about using Microsoft.ACE.OLEDB.12.0 to connect Access Database.

    Please see also:

    http://stackoverflow.com/questions/238625/microsoft-ace-oledb-12-0-provider-is-not-registered

    Hope it helps.

     

    Have a nice day,


    Jackie Sun [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • Marked as answer by Jackie-Sun Wednesday, March 2, 2011 3:16 AM
    • Unmarked as answer by Alan_chen Friday, May 6, 2011 1:44 AM
    • Marked as answer by Alan_chen Friday, May 6, 2011 1:48 AM
    • Unmarked as answer by Alan_chen Friday, May 6, 2011 1:50 AM
    Friday, February 25, 2011 3:54 AM
  • So thats actually a "No" then, there is no official documentation available.

     

    Shame the mod decided their own answer was good enough and marked it as answered (as appears to be the norm - I suppose it makes their stats look good)!

    • Proposed as answer by Dougbo Thursday, July 21, 2011 3:40 AM
    • Marked as answer by Joshua Honig Wednesday, July 27, 2011 1:10 PM
    Thursday, May 5, 2011 2:22 PM
  • So thats actually a "No" then, there is no official documentation available.


    Hello durnster,

    Thanks for your reply.

    Actually what you said about the OP's question is right, that's what I mean in my previous reply.

    However, I think though there's no official documentions recently, I also would try my best to give the customer some useful information to help him. And I hope so. Anyway, this is an positive way, right?

    If you have any questions, please feel free to let me know.

     

    Have a nice day,


    Jackie Sun [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Friday, May 6, 2011 5:15 AM