ODBC Call failed - Report works but queries doesn't

[dungstar]

I have an Access front-end linked to an Oracle (7.3) database. I can run a report that is generated by a query I have saved. However, when I open the query itself, I get the "ODBC--Call failed" error.

I set the ODBC TimeOut in the query's property to 0 and I set the ODBC's QueryTimeOut value in the registry to 0 as well (from the default 60). I still experience the same problem. This also happens when I try to open one of my linked-tables (which is also used in this query). Funny thing is I can get the data fine when loading a report or exporting the data to Excel (via VBA source run on a form).

I just tried exported the troubled table itself and I get more detailed message. "ODBC--call failed. [Microsoft][ODBC Driver Manager] Memory allocation failure (#0)"

Anybody have any ideas?! Thanks!!!

 

[IgorB]

I had one day the same problem with linking to SQL Server database.
I cannot explain the exact reason of doing this but if you relink all tables manually or programmatically everything goes nice.