This way the installer will install the ODBC driver of the same bitness. That is why it is important to use the installer that matches the bitness of TDP. The Microsoft Access 20 Runtime redistributable happen to install the necessary drivers. ![]() Do you see this driver? (Make sure you look at the 64-bit Odbc Manager as there is a 32-bit version and they read different parts of the registry. You could confirm this on your pc by gong to the 64-bit ODBC Manager and looking at the Driver list. Microsoft stopped (or forgot) to install the Office ODBC drivers. The problem of why we can’t connect to Excel or Access with newer versions of Office is really simple. ![]() I started out using Office 64-bit, but I concur it is too buggy so I went back to 32-bit Office. Yes, you can use TDP 64-bit with 32-bit Office. I asked them to set up webex with you but the person assigned to your ticket is out today. Just wanted to get some type of expert feedback that can help me get around this issue. csv or excel format and then link to them, but Access gives you the ability to create one link and have endless amounts of tables to reference with only creating that one link to the database, versus individual links to csv or excel files. I was just checking to see if any of you all have any other ideas that I could try to either continue to try to get 4.1 to work with the 32 bit access somehow, or if there’s any other approaches I could take? I will say, I could send the files to. Therefore, I cannot update any of my processes that use Access databases for storage of tables for reuse later through links to the access db. The issue I have is that I’m going to have a difficult time getting my company to switch me over to a 64 bit version of access. Of course, I get how they are having issues communicating because it needs access odbc drivers on the 64 bit odbc side. I get the message “You will need to install 64-bit version of MS Access Database Engine to connect” when trying to connect to any access db’s from TDP 4.1 64 bit. Just wondering if you’ve seen any discussions or questions regarding TDP 4.1 which is 64 bit not being able to connect to a 32 bit MS Access database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |