The Microsoft Jet database engine cannot find the input table or q

[Imran Bukhari]

Hi,

My application is in VB.NET and I am using Access database on shared
drive. Multiple users use application at same time.

Connection string: @"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=Z:\\NewTables.mdb;Mode=Share Deny None";

I am opening connection when application starts and using same connection
in application. I have also put checked for connection state before executing
any query so in case if connection is closed, I am reopening that.

Normally application works fine for all users without any problem. But
some times if user keep running application for long time without doing any
operation and than if they do any operation, application gives error as "The
Microsoft Jet database engine cannot find the input table or query 'Table
Name'"

I do not understand cause of this problem as same application gives no
error normally if same operation is performed by user. It gives error only if
applicaiton is running for long time without performing any action.

Just to explain with example:

I have one form with data grid and I am filling it on loading of page with
very simple query "Select ClientID,FirmName from MAD where Deleted=0 and
MAD.RIAContact <> 0 AND FirmName <> '' AND CounterpartyType <> ''"

This query gets executed fine and data grid gets filled with data. Now if
I let this form open for long period of time without performing any operation
and than if I press on refresh data button which calls same function which
have above given query, application shows me error "The Microsoft Jet
database engine cannot find the input table or query 'MAD'"

I would really appriciate if any one can help me resolving this issue.

 

[Imran Bukhari]

Hi,

Just to share information so that if any one get similar issue they can
be helped.


Reason for error was network connectivity. One of below given two
possibilities will generate such error.

possibility 1:

You can replicate the error message by getting on a machine that was
accessing the access database remotely (the database was on another machine)
and pulling the network cable before your code was about to make its query.
So error message came about because the network connection / connection to
the machine with the db was interrupted.

possibility 2:

In may case when I unplugged network cable, application was still working as
I have already put check for network availability. Then I tried another
scenario - My applicaiton is using shared drive and any how if machine on
which database is exist start not responding or shared drive gets unreachable
- This time I got error.