Object invalid or no longer set

[cORDOBEx]

I'm using an Access 2000 aplication, wich originally was linked to another Access database. I changed the link to the same tables in SQL 7.0. Everything seem to run pretty much the same, but I'm having problems with some queries.
The error message I'm getting is:
<color red>&quot;Object invalid or no longer set&quot;</color>, and the query is not executed at all.
I know there's an issue between Access an Oracle, but I don't know anything between Access and SQL.
Any help or tip will be very appreciated.

 

[petermeachem]

what's the code look like Peter Meachem
peter@accuflight.com