2147217865 Microsoft Office Access database engine cannot find theinput table or query

[rm]

I have a database that is being shared by multiple users. In the
database a stored query exists that works without issue over 95% of
the time. As a matter of fact I just counted - it has failed 26 times
and worked over 5,000 times.

We get the error posted in the subject line.-2147217865: The Microsoft
Office Access database engine cannot find the input table or query
'your_query'. Make sure it exists and that its name is spelled
correctly.

Is this error raised due to the sharing of the DB? (I warned the user
group at the outset that this is not a "multi-user" application.)

By the way - I tried using a disconnected front end - slower than snot
rolling down hill in December.

 

[Klatuu]

Your failure rate is actually .0052, which is not bad.
If this is an unsplit database located on a shared folder used by multiple
users, I am suprised it has worked this long.

It sounds like corruption is starting. Here is what I would suggest.

make a backup copy of your database.
compact and repair it
Create a new mdb
Copy all the objects from the old mdb to the new mdb
split the database
put the back end on the shared folder
deploy a copy of the front end to each user.

Tell the client it has to be that way to avoid future problems that will
only get worse with time.

 

[Tony Toews [MVP]]

Is this error raised due to the sharing of the DB? (I warned the user
group at the outset that this is not a "multi-user" application.)

What do you mean by not a multi user application. Access works quite
well with multiple users. Although you need to follow some rules.

By the way - I tried using a disconnected front end - slower than snot
rolling down hill in December.

What do you mean by disconnected front end? Using linked tables?

Access Performance FAQ
http://www.granite.ab.ca/access/performancefaq.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/