"Data type not supported" plight

[greaseman]

I have an application that uses Oracle 8.i remotely. The application selects tables from Oracle, opens them, and ultimately uses the selected open table to create a temporary Access table on a PC's hard drive; the user can then manipulate the Access data locally and then save the data back to the remote Oracle database.

This works great on several PCs where I work, however one PC is giving me fits. When I attempt to select an Oracle table to create the local Access table, I get the following message:
"Run-time error '-2147467259 (80004005)': Data type is not supported"

We are using Jet Providers internally and are using Jet 4.0. The PC causing fits is using Access 2003.

Might the problem be caused by incompatibility between Access 2003 and Jet 4.0? Has anyone else encountered this issue? I tried searching this forum and also the Microsoft web site, but did not have luck. This is driving me slightly more nuts.

Thanks in advance to all who reply!

 

[greaseman]

Anybody ??

 

[The_Doc_Man]

My first thought is that you might have a missing reference somewhere on the offending PC. Have you checked that.