HI
I am using a 32 bit version of PowerBuilder.
We have a 64 bit version of MS Access that has the suffix .accdb.
I would like to connect PB to that database. Is it possible using PB?
I do not seem to able to see any 64 bit drivers in PB.
Thank you very much
Tom
Hi Tom,
I'm wondering what version of Office/ MS Access you have but yes, you should be able to do this. Both the 32 bit driver and the 64 bit driver can co-exist on the same machine irrespective of what the bitness is of your MS Access install...but requires specific drivers or a special set of steps:
1) My understanding is that you should be able to install the 2007 Microsoft Access Database Engine alongside the 64 bit drivers, but maybe that engine is too old for you so...
2) This is not intuitive and does potentially involve a registry edit as well as a command line install but a work-around for this is actually outlined by Microsoft. Have a look at this link for the specifics: https://support.microsoft.com/en-us/topic/unable-to-establish-connection-to-access-database-engine-ole-db-in-power-automate-desktop-ed7bb958-3e24-4ff7-9e7e-46cbb9d730c7
Since you already have the 64 bit drivers installed you may only need to do steps 5 and 6.
Here is a snapshot of one of my machines with both drivers installed:
HTH...regards,
Mark
Wonderful information. I will pass this on to our network people and see if that can load both.
They are much better at that than I am. I will let you know how it goes.
I finally got the 32 bit driver to work. I just want to thank yo so much for all your helpful information.
Tom