Hello:

We have a mature Acc2003 app which out of the clear blue, started
exhibiting"-2147217865: Could not execute query; could not find linked table"
error when executing. I have decompiled, compacted/repaired, used linked
table mgr, deleteted the link and reestablished and the error keeps coming
back. This is maddening. Would anyone have any clue as to how to diagnose
this?

The back end table is an Oracle 9.2.0.8.0 table. Sometimes, reestablishing
the link would work. It no longer seems to. I also check "save password"
when reestablishing the link.

any help would be appreciated. thank you

--Harvey

You are most likely dropping connections. That could be a hardware problem,
or the Oracle admin could have made changes which are causing the drop.
Strictly speaking, the problem is outside the realm of the Access
application. Have IT check the NICs on the machines with the problems. If
it's all of them, it is most likely a switch, router, or server NIC, or an
Oracle problem. Once you are assured of your hardware, check the Oracle
Connection Manager for timeouts, etc.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Harvey" <(E-Mail Removed)> wrote in message
news:18FCAA7C-AB81-46C4-A4D6-(E-Mail Removed)...
> Hello:
>
> We have a mature Acc2003 app which out of the clear blue, started
> exhibiting"-2147217865: Could not execute query; could not find linked
> table"
> error when executing. I have decompiled, compacted/repaired, used linked
> table mgr, deleteted the link and reestablished and the error keeps coming
> back. This is maddening. Would anyone have any clue as to how to diagnose
> this?
>
> The back end table is an Oracle 9.2.0.8.0 table. Sometimes, reestablishing
> the link would work. It no longer seems to. I also check "save password"
> when reestablishing the link.
>
> any help would be appreciated. thank you
>
> --Harvey
>

Thanks Arvin, but I have the feeling this is not the problem. I can login to
the Oracle db fine in Sql*Plus anytime. Access works fine as well once I
reestablish the link. But as soon as I close the access app and reopen, the
link is broken again. Doesn't this sound like some problem in Access?



"Arvin Meyer MVP" wrote:

> You are most likely dropping connections. That could be a hardware problem,
> or the Oracle admin could have made changes which are causing the drop.
> Strictly speaking, the problem is outside the realm of the Access
> application. Have IT check the NICs on the machines with the problems. If
> it's all of them, it is most likely a switch, router, or server NIC, or an
> Oracle problem. Once you are assured of your hardware, check the Oracle
> Connection Manager for timeouts, etc.
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
>
>
> "Harvey" <(E-Mail Removed)> wrote in message
> news:18FCAA7C-AB81-46C4-A4D6-(E-Mail Removed)...
> > Hello:
> >
> > We have a mature Acc2003 app which out of the clear blue, started
> > exhibiting"-2147217865: Could not execute query; could not find linked
> > table"
> > error when executing. I have decompiled, compacted/repaired, used linked
> > table mgr, deleteted the link and reestablished and the error keeps coming
> > back. This is maddening. Would anyone have any clue as to how to diagnose
> > this?
> >
> > The back end table is an Oracle 9.2.0.8.0 table. Sometimes, reestablishing
> > the link would work. It no longer seems to. I also check "save password"
> > when reestablishing the link.
> >
> > any help would be appreciated. thank you
> >
> > --Harvey
> >
>
>
>

Sounds more like an ODBC problem. I'd still check the Oracle Connection
Manager.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Harvey" <(E-Mail Removed)> wrote in message
news:9860D805-6C3B-42A6-87DA-(E-Mail Removed)...
> Thanks Arvin, but I have the feeling this is not the problem. I can login
> to
> the Oracle db fine in Sql*Plus anytime. Access works fine as well once I
> reestablish the link. But as soon as I close the access app and reopen,
> the
> link is broken again. Doesn't this sound like some problem in Access?
>
>
>
> "Arvin Meyer MVP" wrote:
>
>> You are most likely dropping connections. That could be a hardware
>> problem,
>> or the Oracle admin could have made changes which are causing the drop.
>> Strictly speaking, the problem is outside the realm of the Access
>> application. Have IT check the NICs on the machines with the problems. If
>> it's all of them, it is most likely a switch, router, or server NIC, or
>> an
>> Oracle problem. Once you are assured of your hardware, check the Oracle
>> Connection Manager for timeouts, etc.
>> --
>> Arvin Meyer, MCP, MVP
>> http://www.datastrat.com
>> http://www.mvps.org/access
>> http://www.accessmvp.com
>>
>>
>> "Harvey" <(E-Mail Removed)> wrote in message
>> news:18FCAA7C-AB81-46C4-A4D6-(E-Mail Removed)...
>> > Hello:
>> >
>> > We have a mature Acc2003 app which out of the clear blue, started
>> > exhibiting"-2147217865: Could not execute query; could not find linked
>> > table"
>> > error when executing. I have decompiled, compacted/repaired, used
>> > linked
>> > table mgr, deleteted the link and reestablished and the error keeps
>> > coming
>> > back. This is maddening. Would anyone have any clue as to how to
>> > diagnose
>> > this?
>> >
>> > The back end table is an Oracle 9.2.0.8.0 table. Sometimes,
>> > reestablishing
>> > the link would work. It no longer seems to. I also check "save
>> > password"
>> > when reestablishing the link.
>> >
>> > any help would be appreciated. thank you
>> >
>> > --Harvey
>> >
>>
>>
>>