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.
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.
Of course, I get how they are having issues communicating because it needs access odbc drivers on the 64 bit odbc side.
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.
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.
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 .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.
Just wanted to get some type of expert feedback that can help me get around this issue.
Thanks a bunch as always!