none
How to find And uninstall all copies of Microsoft Access DataBase Engine x32 RRS feed

  • Question

  • Hi, I hope that I am posting to the right form as I am pretty new to mdsn. If not, please let me know and I will move my post to the proper form.

    I can not work with access because I get the error: "microsoft ace oledb 12.0 provider is not registered" so I was trying to install 

    Microsoft Access Database Engine 2010 Redistributable

    and it did not work because:

    You cannot install the 64-bit version of Microsoft Access Database Engine because you currently have 32-bit Office Product installed

      after I have received this error I spent days trying to install the product using any solution that the internet has to offer: Installing with passive, remove the files manually, use the control panel etc.. 

    I have come to the conclusion that the only thing that will help me is a cmd command that just finds and removes all the x32 bit versions of the file, however I know a little about cmd. how can I do such operation?


    • Edited by avivgood Wednesday, October 16, 2019 3:28 PM
    Wednesday, October 16, 2019 3:26 PM

Answers

  • Does the C# test code work with a .accdb file ?

    Won'n let me run: namespace oledb command does not exist in the current context. about the file,

    Add a reference to System.Data
    • Marked as answer by avivgood Saturday, October 19, 2019 1:43 PM
    Thursday, October 17, 2019 3:24 PM

All replies

  •  I spent days trying to install the product using any solution that the internet has to offer: Installing with passive, remove the files manually, use the control panel etc.. 

    AccessDatabaseEngine_x64.exe /passive

     (or /quiet) depending on version)

    worked for me (I have now both 32 and 64-bit installed (Windows 10)


    • Edited by Castorix31 Wednesday, October 16, 2019 4:05 PM
    Wednesday, October 16, 2019 4:03 PM
  • Yes I have used passive, and it didn't work, with the same error as installing it without passive
    Wednesday, October 16, 2019 4:14 PM
    • Edited by Castorix31 Wednesday, October 16, 2019 4:21 PM
    Wednesday, October 16, 2019 4:19 PM
  • No error this time, yet when I click "test connection" in VS I get the "the microsoft.ace.oledb.12.0 provider is not registered on the local machine" error
    Wednesday, October 16, 2019 4:30 PM
  • Are you sure the 32-bit version is installed ? (AccessDatabaseEngine.exe)

    to check :

    "c:\Windows\SysWOW64\odbcad32.exe" (32-bit)

    odbcad32.exe (64-bit)

    Dost it work if you test a connection in C#, like :

    string sFile = "E:\\Employees.accdb";                
    System.Data.OleDb.OleDbCommand myCommand = new System.Data.OleDb.OleDbCommand();
    System.Data.OleDb.OleDbConnection myConnection = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + sFile + ";Persist Security Info=False;");
    myConnection.Open();



    • Edited by Castorix31 Thursday, October 17, 2019 9:46 AM
    Thursday, October 17, 2019 9:41 AM
  • I want to the path you sayed and the file is there. What should I do now?
    Thursday, October 17, 2019 11:48 AM
  • I want to the path you sayed and the file is there. What should I do now?

    Which file ?!

    odbcad32 is used to display installed drivers, 32 or 64-bit

    Does the C# test code work with a .accdb file ?

    • Edited by Castorix31 Thursday, October 17, 2019 11:55 AM
    Thursday, October 17, 2019 11:50 AM
  • I want to the path you sayed and the file is there. What should I do now?

    Which file ?!

    odbcad32 is used to display installed drivers, 32 or 64-bit

    Does the C# test code work with a .accdb file ?

    Won'n let me run: namespace oledb command does not exist in the current context. about the file,

    I cant see it in the given file. all I can see is ACEODBC.dll file as access driver


    • Edited by avivgood Thursday, October 17, 2019 2:39 PM
    Thursday, October 17, 2019 2:38 PM
  • Does the C# test code work with a .accdb file ?

    Won'n let me run: namespace oledb command does not exist in the current context. about the file,

    Add a reference to System.Data
    • Marked as answer by avivgood Saturday, October 19, 2019 1:43 PM
    Thursday, October 17, 2019 3:24 PM
  • Tested you code, code the error nhandled Exception: System.Data.OleDb.OleDbException: 'E:\Employees.accdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

    (as expected, I dont have such DB(

    Thursday, October 17, 2019 5:21 PM
  • I have tried it with existing DB and no error. I think that the solution was as simple as adding the nuget package, but I am not sure I have solved it
    • Edited by avivgood Thursday, October 17, 2019 5:25 PM
    Thursday, October 17, 2019 5:23 PM