Very Computer

by **danny_pa** » Fri, 10 Dec 1999 04:00:00

We have an application that uses MFC and ODBC. It gets the following
message while trying to perform an update:

The Microsoft Jet database engine cannot find the input table or
query 'Patients'. Make sure it exists and that its name is spelled
correctly.

The database does contain this table. This problem occurs
intermittently. (If there was no table 'Patients' or it could not be
found, there would be no data at all in the database.) We have not
beenn able to duplicate this problem here.

Does anyone know what may be causing this problem (other than
table 'Patients' not existing)?

Thank you,
Danny Pav

Sent via Deja.com http://www.deja.com/
Before you buy.

by **W. Tucha** » Sat, 11 Dec 1999 04:00:00

A temporary loss of the network connection can produce this error message
if you access the database file over a network share.

> We have an application that uses MFC and ODBC. It gets the following
> message while trying to perform an update:

> The Microsoft Jet database engine cannot find the input table or
> query 'Patients'. Make sure it exists and that its name is spelled
> correctly.

> The database does contain this table. This problem occurs
> intermittently. (If there was no table 'Patients' or it could not be
> found, there would be no data at all in the database.) We have not
> beenn able to duplicate this problem here.

> Does anyone know what may be causing this problem (other than
> table 'Patients' not existing)?

> Thank you,
> Danny Pav

> Sent via Deja.com http://www.deja.com/
> Before you buy.

by **danny_pa** » Sat, 11 Dec 1999 04:00:00

What is a TEMPORARY loss of network connection?

> A temporary loss of the network connection can produce this error
message
> if you access the database file over a network share.

<=== SNIPPED ==>
> > The Microsoft Jet database engine cannot find the input table or
> > query 'Patients'. Make sure it exists and that its name is spelled
> > correctly.

> > The database does contain this table. This problem occurs
> > intermittently. (If there was no table 'Patients' or it could not

<=== SNIPPED ==>

Sent via Deja.com http://www.deja.com/
Before you buy.

by **W. Tucha** » Tue, 14 Dec 1999 04:00:00

Disconnect the network cable and reconnect it after a while or reboot the
file server. The client redirector will reconnect to the server when the
connection is reestablished but access will have some problem after that.

> What is a TEMPORARY loss of network connection?

> > A temporary loss of the network connection can produce this error
> message
> > if you access the database file over a network share.

> <=== SNIPPED ==>
> > > The Microsoft Jet database engine cannot find the input table or
> > > query 'Patients'. Make sure it exists and that its name is spelled
> > > correctly.

> > > The database does contain this table. This problem occurs
> > > intermittently. (If there was no table 'Patients' or it could not
> <=== SNIPPED ==>

> Sent via Deja.com http://www.deja.com/
> Before you buy.

by **danny_pa** » Tue, 14 Dec 1999 04:00:00

Quote:> Disconnect the network cable and reconnect it after a while or reboot
the
> file server. The client redirector will reconnect to the server when
the
> connection is reestablished but access will have some problem after
that.

OK.
Have you witnessed this first hand? We are building a test suite and
are going to try to duplicate it using your suggestions.
Thanks,
Danny Pav

PS. I will report back with the results.

Sent via Deja.com http://www.deja.com/
Before you buy.

by **W. Tucha** » Wed, 15 Dec 1999 04:00:00

Yes, but it depends somewhat on the operating system and driver version.
I've also seen the following message (Win98 client):
The table 'tab1' is already opened exclusively by another user, or it is
already open through the user interface and cannot be manipulated
programmatically.

> > Disconnect the network cable and reconnect it after a while or reboot
> the
> > file server. The client redirector will reconnect to the server when
> the
> > connection is reestablished but access will have some problem after
> that.

> OK.
> Have you witnessed this first hand? We are building a test suite and
> are going to try to duplicate it using your suggestions.
> Thanks,
> Danny Pav

> PS. I will report back with the results.

> Sent via Deja.com http://www.deja.com/
> Before you buy.

by **danny_pa** » Wed, 15 Dec 1999 04:00:00

> Yes, but it depends somewhat on the operating system and driver
version.
> I've also seen the following message (Win98 client):
> The table 'tab1' is already opened exclusively by another user, or it
is
> already open through the user interface and cannot be manipulated
> programmatically.

> > > Disconnect the network cable and reconnect it after a while or
reboot
> > the
> > > file server. The client redirector will reconnect to the server
when
> > the
> > > connection is reestablished but access will have some problem
after
> > that.

> > OK.
> > Have you witnessed this first hand? We are building a test suite
and
> > are going to try to duplicate it using your suggestions.
> > Thanks,
> > Danny Pav

> > PS. I will report back with the results.

W. Tuchan:
We ran our tests. We got these results. If we disconnect the network,
and then reconnect, all calls give that toublesome error. So we are
going to put things into our code to force a close and (re) open of
thje database after that occurs.

Thanks for all your help. We have been getting nowhere with this for
quite some time. Now we can solve this and move on.

Thanks again.

Sent via Deja.com http://www.deja.com/
Before you buy.

Very Computer

Problem: ODBC with MS Access Can't find table

Problem: ODBC with MS Access Can't find table

Problem: ODBC with MS Access Can't find table

Problem: ODBC with MS Access Can't find table

Problem: ODBC with MS Access Can't find table

Problem: ODBC with MS Access Can't find table

Problem: ODBC with MS Access Can't find table

Problem: ODBC with MS Access Can't find table