I have form query setup to pull from an ODBC linked database.
I originally created it and saved it to my personal drive at work, and then copied it over to a shared folder on the network drive. I had no issues using the query, but 2 others were running into ODBC: call failed errors.
they both have oracle and all that stuff on their machines and can use the many other queries that pull data from the same machine source.

the problem was resolved after I deleted the linked table and relinked it.
im not sure why it wouldn’t work in the first place, or why relinking it made the difference.

any ideas?


thanks