I'm trying to connect to a MS ACCESS database from a macro call. Can do it locally from my machine using the MS JET OLEDB provider, however our server does not have that driver. It doesn't have MS Office installed and we are not permitted to install additional drivers on top of the standard OS build. It's a 64 bit server. Any help is greatly appreciated!
I don't think there is a 64bit JET driver. If you have 64bit Office installed, you get the MSOffice 12.0 Access provider which will read Access DB on 64bit. That generates a connection string like:
CONNECT TO [Provider=Microsoft.ACE.OLEDB.12.0;...
I think you are going to have to install something, either 64bit Office or a standalone driver. Search this forum and support.microsoft.com for 64bit drivers for MSAccess to see if a standalone driver package is available,
I see where you're going Rob and get the theory. Interestingly enough, on my laptop I don't have 64 bit office and the call works beautifully using the MSADQL provider. The same call doesn't work on the server. It would be nice if there were a way to utilize some sort of provider that qvconnecter.exe uses within a document for macro's.
I am also working on this same problem. The issue we are seeing is that we are running 64bit QV and 64Bit 2008 R2. But our Database connections have to be to a 32bit Oracle or even Access at this point would be great. In forcing 32 bit through the Load Script this all works great. But when trying to make a call to a database through a Macro it is trying to using the 2008 OS default ODBC pool which is 64bit. Is there a way to force or reference the 32 bit drivers in a VB Based Macro.
Similar to this here. Except force it to go to 32 bit.
