Foxpro/Pegasus Opera data analysis in Access 2000

[Guest_imported]

Since updating to Access 2000 I am unable to use my Union and Select queries. I have tried various methods of linking the Opera/Foxpro data with ODBC drivers, to no avail, I am not familiar with ODBC. The error I get when running refers to an ODBC call failure. I have refreshed the links using links table manager, this does not help. I am not using Opera 32 bit. While using Access 97 I had no problems. I am really struggling here, can anybody help please?
Tony Sullivan.

 

[Guest_imported]

Not really much of a help this but ...

Access 2000 uses a different version of JET. I am not sure whether or not FoxPro is compatible with it, especially if you are running the DOS version.

I cant believe that I actually found someone else who uses Pegasus Opera !!!


Stew