Note To apply this security update, you must have the release version of Access 2016 installed on the computer. To learn more about these vulnerabilities, see Microsoft Security Bulletin MS15-116. If you've got the drivers installed (and you've tried both 32-bit and 64-bit) and it still won't work then I don't have any more ideas.This security update resolves vulnerabilities in Access 2016 that could allow remote code execution if a user opens a specially crafted Microsoft Office file. I hate how this is so finicky, but you really need to make sure that you've got the right drivers installed (and the right bitness depending on the app you're exporting from - SSMS is 32-bit, I think). If that doesn't work, uninstall the 32-bit drivers and install the 64-bit then try exporting to Excel 2010 again. First install the 32-bit version first then try exporting to Excel 2010. Stick with one version of the ACE drivers to start with (start with the one I linked, for 2010 - you don't have to have Office 2010 to install and use the ACE driver of that version) and try both bitness versions. If you didn't install any ACE drivers then you need to do that first, before anything else. The new error you got is the same problem, you don't appear to have that version of the ACE drivers installed, or the bitness of the installed drivers does not match the tool you're using to export - if the app you're using to export is a 32-bit app it'll try to use the 32-bit ACE drivers, if 64-bit, it'll try to use those, and if the right version + bitness that your app expects isn't there, it'll error. What exactly did you try and what are you using (what tool/app) to do the actual export? Did you actually install the drivers I linked to, or did you just try to pick a different export format? That was not what I was suggesting but it was a good thing to try as you may have had those drivers already installed (though apparently you don't). I sent you a private message earlier, wasn't able to reply in forum due to getting an error. This time I tried selecting Excel 2016 and I got the same message except this time it read OLEDB.16.0 instead OLEDB.12.0. The install will complain if you try to install a version that doesn't match the bitness of your Office install). So, if you have Office on your machine, try installing the version of the driver that mirrors the bitness of your Microsoft Office installation (if you have Office installed - if not or you don't know maybe start with the 32-bit version, if that doesn't work uninstall it and try the 64-bit version. Also, depending on how you're exporting, there are 32-bit and 64-bit versions of the thing.if you're exporting from SSIS for instance, you need to make sure you get the version with the correct "bitness", and installing the 32-bit version when you have 64-bit Office installed is a serious pain as the two don't like to be installed "side by side" (but it can be done). You can download that from here: There are different versions of this thing for different versions of Microsoft Office (one for 2007, 2010, 2016, etc).if this isn't the one you need then you might Google for that specific error message to find the correct version, should find plenty of links to other versions. That error refers to the "Microsoft Access Database Engine 2010 Redistributable" I think. There are different versions of this thing for different versions of Microsoft Office (one for 2007, 2010, 2016, etc).if this isn't the one you need then you might Google for that specific error message to find the correct version, should find plenty of links to other versions.Īlso, depending on how you're exporting, there are 32-bit and 64-bit versions of the thing.if you're exporting from SSIS for instance, you need to make sure you get the version with the correct "bitness", and installing the 32-bit version when you have 64-bit Office installed is a serious pain as the two don't like to be installed "side by side" (but it can be done).
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |