Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2008
    Posts
    14

    Unanswered: Looking for VB6 OLEDB Provider for MA-Access 2007

    I have a VB6 project that runs very okay.

    I had used ADO & OLEDB for JET.4.0.

    Now I wish to connect the VB6 project (ADO connection object) to MS-Access 2007 db but I don't want to install MS-Access 2007 on the production machine.

    How may I obtain & register the necessary DLLs. I have combed microsoft site but no luck.

    thanks


    Vie
    @Abuja
    Last edited by Imatools; 08-20-08 at 14:43.

  2. #2
    Join Date
    Jul 2008
    Posts
    14
    Sorry I should have posted this long time - as soon as I was able to fix the challenge.

    This is the PROVIDER literal to use in the coonection string of your VB6 ado.net connection object.

    PROVIDER=Microsoft.ACE.OLEDB.12.0

    HOWEVER you will do well to download accessDatabaseEngine from the Microsoft site and install it on your computer.

    enjoy!

    Vie
    @Abuja

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •