Search VB 2010

Wednesday, June 12, 2013

Visual Basic Online Course - The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

MS-Access 2010 for VB 2010
MS-Access 2010 for VB 2010
Visual Basic 2010 Error Message :
InvalidOperationException was unhandled
" The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine" ?
This error message means that the machine [Computer, Laptop] that you are trying to run your application on, doesn't have MS-Access 2007 installed, or not installed properly. Some developers just pack their applications and send it to the client :
- relying on - that the client have MS-Office 2007/2010 installed already and won't never crash or updated to 2010, 
- or they just did not include the proper component along with their package, 
- or even worse they may not know what exactly should they do to make it work on the client's machine.

╚Ž╣ To get this error message to go away, you need to include this file in your package :

2007 Microsoft Office System Update: Redistributable Primary Interop Assemblies

 Some think that Office 2007 should be installed on a client's machine in order for the application to run clean or properly with any bugs, No, you can include this tool for both [Win32 and Win64] and don't count the client to have Office installed or not.

Get the file from here [AccessDatabaseEngine] for both Win64bit and Win32bit, available in all languages supported by Microsoft. Here are some information about downloading and installing the tool :

When you first click on Download on the Download page, you will see :

Choose the download you want

File Name

AccessDatabaseEngine.exe    25.6 MB
AccessDatabaseEngine_x64.exe    28.1 MB

The download should start for selected file ...
Office

Thank you for downloading

The 2007 Microsoft Office system Primary Interop Assemblies (PIA) redistributable is a Microsoft Windows Installer package that contains the Primary Interop Assemblies for 2007 Microsoft Office system products.

 You could see a reference to Office 2010, don't panic, this is the same, it's the same tool that supports also Office 2010. If your application relies on MS-Access 2010 Database and you got the same meaningful Error message then the same cause needs to be fixed by including this very same file into your package without relying on the client's machine to have MS-Office 2010 or MS-Access 2010 installed on it.

Thank you for downloading

  • Microsoft Access Database Engine 2010 Redistributable

    After the download finishes, pick up the corresponding file that meets your OS kind [32 or 64]

    ♥ Installation Instructions ♥

    To install this download:
    1. Download the file by clicking the Download button and saving the file to your hard disk.
    2. Double-click the AccessDatabaseEngine.exe program file on your hard disk to start the setup program.
    3. Follow the instructions on the screen to complete the installation.
    To use this download:
    1. If you are the user of an application, consult your application documentation for details on how to use the appropriate driver.
    2. If you are an application developer using OLEDB, set the Provider argument of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0”

      If you are connecting to Microsoft Office Excel data, add the appropriate Extended Properties of the OLEDB connection string based on the Excel file type:

      File Type (extension)                                             Extended Properties
      ---------------------------------------------------------------------------------------------
      Excel 97-2003 Workbook (.xls)                                  "Excel 8.0"
      Excel 2007-2010 Workbook (.xlsx)                             "Excel 12.0 Xml"
      Excel 2007-2010 Macro-enabled workbook (.xlsm)      "Excel 12.0 Macro"
      Excel 2007-2010 Non-XML binary workbook (.xlsb)      "Excel 12.0"

    3. If you are an application developer using ODBC to connect to Microsoft Office Access data, set the Connection String to “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file”
    4. If you are an application developer using ODBC to connect to Microsoft Office Excel data, set the Connection String to “Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file”
    To remove this download:
    To remove the download file itself, delete the file AccessDatabaseEngine.exe
    1. On the Start menu, point to Settings and then click Control Panel.
    2. Double-click Add/Remove Programs.
    3. In the list of currently installed programs, select “Microsoft Access database engine 2010” and then click Remove or Add/Remove. If a dialog box appears, follow the instructions to remove the program.
    4. Click Yes or OK to confirm that you want to remove the program.  

     

    Additional Information


      This package contains components that are at the same version as the “The 2007 Microsoft Office Suite Service Pack 1 (SP1)” release.

      The Office System Drivers are only supported under certain scenarios, including:

      1. Desktop applications which read from and write to various files formats including Microsoft Office Access, Microsoft Office Excel and text files.
      2. To transfer data between supported file formats and a database repository, such as SQL Server. For example, to transfer data from an Excel workbook into SQL Server using the SQL Server Import and Export Wizard or SQL Server Integration Services (provided the SSIS jobs run in the context of a logged-on user with a valid HKEY_CURRENT_USER registry hive).
 Source for Installation instruction (Microsoft)

Here are some online Visual Basic lessons and courses :

31 comments:

  1. Hi there, after reading this remarkable article i am as well glad to share my experience here with colleagues.


    Also visit my weblog: Sample Email Templates

    ReplyDelete
  2. It is not my first time to go to see this site, i
    am browsing this site dailly and obtain pleasant information from here daily.


    My homepage; magento email templates :: ::

    ReplyDelete
  3. Hi, its pleasant piece of writing concerning media print,
    we all be aware of media is a fantastic source of facts.


    My blog - cedar rapids iowa - -

    ReplyDelete
  4. Asking questions are truly pleasant thing if you are not understanding
    anything fully, but this piece of writing presents fastidious
    understanding even.

    Feel free to surf to my web blog small business debt restructuring
    **

    ReplyDelete
  5. Wow that was unusual. I just wrote an really long comment but after I clicked submit my comment didn't show up. Grrrr... well I'm not writing all that over again.
    Regardless, just wanted to say superb blog!

    Here is my blog post :: money market account interest rate ()

    ReplyDelete
  6. get his and hers gillette razor samples

    venus gillette samples

    ReplyDelete
  7. Ρoste rudement attrayant

    Also viksit my blog post videos porno

    ReplyDelete
  8. Јe remarque tօut de suite que vous connaissez supеrbement bien le
    sսjet

    Feel free to visit mmy web site ... vidéo porno gratuite

    ReplyDelete
  9. Εxcellent poste une fois de plus

    Have a look at mmy pаge; films porno amateurs

    ReplyDelete
  10. Јe suis venu sur ce site web par hasard et je ne le regrette nullеment !



    Visit my weblog ... films porno amateurs

    ReplyDelete
  11. Mince je pеnsais justement rédiger un post pareіl à celui


    Also visit mу web page: XXX fille de joie

    ReplyDelete
  12. Je ѕuis entièrement en aϲcord avec toi

    Here is my web page ... 69streaming.fr

    ReplyDelete
  13. Je νazis terminer de regarder tout ça dans la semaine

    Feel free to surf to my weƄ blog :: blog gratuit porno

    ReplyDelete
  14. C'eѕt infiniment de la joie de passer suur votre site

    Alsо visit my weblog ... film de sexe

    ReplyDelete
  15. Post rudeement cаptivant

    Feel frwe to visit my web-site - épicurienne sexy

    ReplyDelete
  16. C'est bizarre je comptaiѕ rédiger un petit poste semblaЬle au tiens

    My weeb blog; X

    ReplyDelete
  17. Sսjet incroyablement cultivant !

    my blog; sexe en streaming hard

    ReplyDelete
  18. Unnе fօis de plus սn ρost clairement plaisant

    Alsօ visit my weblog - film hardcore en streaming

    ReplyDelete
  19. Je νludrai vous diгe que c'est vrɑiment du рlaisir de visiter
    votre site internet

    Feel free to surf to my web page :: videos porno

    ReplyDelete
  20. Très bon ƿoste : j'en discutterɑi aprèѕ avec certains de
    mes potes

    Also visit my webb blog; www.jeune-ronde-jolie.fr

    ReplyDelete
  21. Cet artiϲle est vraiment remplі de superbes conseils

    my website - sexe exotique

    ReplyDelete
  22. On va dire quе ce n'est gսèreerroné !

    Also visit my blog post: www.interethnique.fr

    ReplyDelete
  23. Tіens je pensais écrire un petit article similaіre à celui là

    My web blog :: video de sexe gratuite

    ReplyDelete
  24. Poste trop ρlaisant

    Stop by my sіte: vidéo érotique gratuite

    ReplyDelete
  25. Unne fօis de plus unn poste ѕincèrement intéressant

    Feeel free to ѵisit my webb page; film pour adulte

    ReplyDelete
  26. Incrօyable poste : pérеnnisez de cette façon

    Fеel free to suf to my webpage: masturbation avec gode

    ReplyDelete
  27. Tіens je comptais justement rédiger un petit
    aeticle identique аu tіens

    my website vidéos sexe

    ReplyDelete

  28. It is very good and useful for students and developer .Learned a lot of new things from your post!Good creation ,thanks for good info . Net Online Training Bangalore

    ReplyDelete

Visual Basic Online Course

Visual Basic Courses - Share