![]() When I had problems the first time executing from another directory I moved it to my version of his directory to match syntax perfectly. I can’t fathom that all these others folks had no issues using that screen shot as a guide. Are you saying that screen shot image above in this article has incorrect syntax?įyi - I’m on a win 7 64 bit machine and my ms office was loaded as 64 bit… Hi Meagan - Thanks for the tip and the pointer, but man am i confused now. So I’m posting this on my blog to make this info easier to find for me as well as you. I wrote up a document for this a while back for a client, but I can never remember where I put it. Note: A helpful commenter has informed me that for Access 2016 the switch is /quiet rather than /passive. Delete or rename the mso.dll registry value in the following registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Common\FilesPaths.Follow it with a space and then “/passive” and then hit Enter.Type the file path and file name for your Access Database Engine install file.Option B: Install from the Command Line and Use the Passive Switch It doesn’t have the check to see what other products are on your machine and can co-exist peacefully with the 64-bit 2010 Access engine. ![]() The 2007 Access database engine can read the same format, but didn’t have a 64-bit install. Option A: Install the 2007 Office System Driver: Data Connectivity Components ![]() There are two options for getting the other version installed. If you try, you will get an error message. You cannot install the 2010 Access database engine with a different processing architecture (bittedness) from your Office install (or install both versions of the 2010 Access database engine) without a workaround. If you have ever attempted this, you know there is a secret. I started by installing the 64-bit Microsoft Access Database Engine 2010 Redistributable. I needed both the 32-bit and the 64-bit adapters to cover my various use cases. The ‘.12.0’ provider is not registered on the local machine. ![]() If you try to do either of those things without the ACE OLE DB provider you will get a message like the one below. I sometimes work with SSIS locally to import data from Excel and occasionally do demos with Power BI where I read from an Access database so I needed to install the ACE OLE DB provider. Do you need to complete only the Migration Wizard and then have no plans to link to an Excel spreadsheet? If so, you could uninstall Office, install the required Access Database Engine which matches the OS version, complete the migration, uninstall the Access Database Engine and install Office.I recently got a new laptop and had to go through the ritual of reinstalling all my programs and drivers. Is this server used by end-users who run Microsoft Office or is this server only used for running the MR services? If no end users will be running Office from the server, you could uninstall Office and install only the needed Access Database Engine (if you need to do one of the items listed above). You do not need the Access Database Engine just to export reports to Excel - this is a feature built into MR. Design reports which pull data from an Excel spreadsheet Complete the FRx Migration Wizard to migrate reports from FRxĢ. Note that you only need the Access Database Engine installed for MR if you plan to:ġ. Also, MR does require that the Access Database engine version matches the OS architecture as well as the MR version (all 32-bit or all 64-bit based on the OS). It is generally not supported to use the "passive" switch as it can lead to other problems down the road, and I believe this option is not supported by the Microsoft Office support team for a production environment. Another article which discusses this is:Ģ269468 You receive the error message "You cannot install the 64-bit version of Office 2010 because you have 32-bit Office products installed" It is a limitation of Microsoft Office that you cannot install both the 32-bit and 64-bit components of Microsoft Office on the same computer.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |