Results 1 to 3 of 3

Thread: Better database access method

  1. #1

    Thread Starter
    New Member
    Join Date
    Sep 2018

    Better database access method


    I'm writing an application and using database, I'm using this method to access database file

    dbProvider As String = "Provider=Microsoft.ACE.OLEDB.12.0;Jet OLEDBatabase Password=123;"

    But I face "The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine" on many target PCs, some PCs working fine, some are not.

    My question is :

    is there a better method to access database without caring about this ACE.OLEDB.12 error ? not matter what PC or office ver is ?

    I'm doing reading/writing/updating/deleteing, using sql query

    Thank you all

  2. #2
    Frenzied Member
    Join Date
    May 2014
    Central Europe

    Re: Better database access method

    afaik the driver you are using is the recommended and should be the fastest. it should be availble on all machines that have MS Access installed. there are other possibilities: https://www.connectionstrings.com/access/
    but i think all the JET ones are only coming with access, but i think MS allowes to install the drivers.

  3. #3
    .NUT jmcilhinney's Avatar
    Join Date
    May 2005
    Sydney, Australia

    Re: Better database access method

    Are you using an MDB file or an ACCDB file? If it's the former then you should use the Jet provider rather than ACE. If it's the latter then you must use ACE, so anyone who doesn't have Access installed already needs to install the Access Database Engine, which they can download or you can provide with your application.

Posting Permissions

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


Click Here to Expand Forum to Full Width