I have a 32bit Visual Basic program running on a 64bit workstation that imports XL data using a 32 bit Access database Engine.
We have to replace all of the 32 bit Access installations with 64 bit access database engines over two years, so some workstations will have the 32 bit Access Database Engine and some the 64 bit Access Database Engine.
How do I modify my program to work with the 32 bit or 64bit Access database Engine, depending on whichever is present?
We have some 5,000 workstations so replacing the 32 bit access database Engine with the 64 bit Access database Engine over night is not a likely scenario.