none
{"The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine."} RRS feed

  • Question

  • I have a XP machine running - Vb.NET 2005 - office 2007.

    I have compiled a program that, when distributed gives the above error on

    a Windows 7 machine running office 2010.

    I have

    "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\STAMPS\Stamps.mdb"

    I have tried installing all the accessDatabaseEngine.exe files on the target machine, I can find.

    but this error still occurs.

    Thursday, September 27, 2012 10:35 AM

Answers

  • You can get to Configuration Properties another way. From Solution Explorer right click on the solution and select the Properties menu item. This will display the solution property pages dialog. Select Configuration Properties from the ListView on the left. Then you can change the Platform for the project from AnyCPU to x86 (you may have to add x86). When deploying your app you will want to change the Configuration property from Debug to Release.

    To get the menu item back under Build:

    http://blog.newslacker.net/2008/03/visual-studio-2005-missing.html


    Paul ~~~~ Microsoft MVP (Visual Basic)

    Tuesday, October 2, 2012 12:33 PM

All replies

  • Is the Windows 7 machine 32-bit or 64-bit? If the app was compiled with a Platform option (Build...Configuration Manager...) of AnyCPU then it will run 64-bit on 64-bit Windows. In this instance you would need to install the 64-bit Access Database Engine (AccessDatabaseEngine_x64.exe).


    Paul ~~~~ Microsoft MVP (Visual Basic)

    Thursday, September 27, 2012 12:47 PM
  • It is a 32 bit Office Product.

    When client tried to install the accessdatabaseengine_x64 (MADE_x64)the following resulted.

    "You cannot install the 64b-bit version of MADE2010  because you currently have 32bit Office roducts installed. If you want to install 64-bit MADE 20120 you will first need to remove the 32-bit installation of Office Products. After uninstallatiuon the following product(s), rerun setup in order to install 64bit MADE2010:

    Miocrosoft Office Professional Hybrid 2007 "

    If the client is running 32bit Office MADE.exe should work BUT DOES NOT

    All help greatly appreciated.

    Monday, October 1, 2012 1:34 AM
  • If the client is running 32-bit office then you should set the Platform option (Build...Configuration Manager...) of the project to x86. This will force it to run 32-bit and use the 32-bit ACE OLEDB Provider (which is already installed).

    Paul ~~~~ Microsoft MVP (Visual Basic)

    Monday, October 1, 2012 2:43 AM
  • Thank you Paul,

    Unfortunately I have no idea what

    "set the Platform option (Build...Configuration Manager...) of the project to x86"  means.

      Could you please elucidate.

    Monday, October 1, 2012 11:02 PM
  • Yes, Build is a top level menu item in Visual Studio. Configuration Manager is in the Build drop down menu. Platform is an option in the Configuration Manager dialog.

    Paul ~~~~ Microsoft MVP (Visual Basic)


    Tuesday, October 2, 2012 2:01 AM
  • Paul,

    It may be my VB  see below.

    Microsoft Visual Studio 2005
    Version 8.0.50727.42  (RTM.050727-4200)
    Microsoft .NET Framework
    Version 2.0.50727 SP2

    Installed Edition: Professional

    Microsoft Visual Basic 2005   77626-009-0000007-41412
    Microsoft Visual Basic 2005

    Microsoft Visual C# 2005   77626-009-0000007-41412
    Microsoft Visual C# 2005

    Microsoft Visual C++ 2005   77626-009-0000007-41412
    Microsoft Visual C++ 2005

    Microsoft Visual J# 2005   77626-009-0000007-41412
    Microsoft Visual J# 2005

    Microsoft Visual Web Developer 2005   77626-009-0000007-41412
    Microsoft Visual Web Developer 2005

    Crystal Reports    AAC60-G0CSA4B-V7000AY
    Crystal Reports for Visual Studio 2005


    Security Update for Microsoft Visual Studio 2005 Professional Edition - ENU (KB925674)  
    This Security Update is for Microsoft Visual Studio 2005 Professional Edition - ENU. \n
    If you later install a more recent service pack, this Security Update will be uninstalled automatically. \n
    For more information, visit http://support.microsoft.com/kb/925674

    Security Update for Microsoft Visual Studio 2005 Professional Edition - ENU (KB937060)  
    This Security Update is for Microsoft Visual Studio 2005 Professional Edition - ENU.
    If you later install a more recent service pack, this Security Update will be uninstalled automatically.
    For more information, visit http://support.microsoft.com/kb/937060

    Under build there is

    Build XXX

    Rebuild xxx

    Clean xxx

    These three do not give dialog boxes

    then

    Publish XXX which gives a number of dialog boxes but no mention of configuration manager

    and that is all that is under "Build"

    Tuesday, October 2, 2012 4:15 AM
  • You can get to Configuration Properties another way. From Solution Explorer right click on the solution and select the Properties menu item. This will display the solution property pages dialog. Select Configuration Properties from the ListView on the left. Then you can change the Platform for the project from AnyCPU to x86 (you may have to add x86). When deploying your app you will want to change the Configuration property from Debug to Release.

    To get the menu item back under Build:

    http://blog.newslacker.net/2008/03/visual-studio-2005-missing.html


    Paul ~~~~ Microsoft MVP (Visual Basic)

    Tuesday, October 2, 2012 12:33 PM