Problem with 32-bit ODBC and 64-bit Access

[MarshaP]

I posted this in the Access - Tables section, but have not had a response, so I thought I would try here.

I have several Access applications that use 3rd party software. One of the databases is Visual Fox Pro, another is Pervasive (btrieve). As far as I know, there is no 64-bit driver for these two databases. I am able to set up the ODBC on a 64-bit laptop using the odbc32ad.exe in SysWOW64 folder. But then I am unable to see it from my 64-bit Access. Is there a way around this?

Thanks for any help.

 

[SkipVought]

In Windows SEARCH for odbc 32.
You should see a data sources (odbc) 32 bit. This is where your your base odbc drivers for 32 bit should be configured.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[MarshaP]

Yes, I have the 32-bit ODBC set up. Is there a way to get 64-bit Access to use it?

 

[SkipVought]

You may have to use the 32 bit driver.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}