I have a user who is getting the follwoing error when trying to update or reset queries from an access database.

The microsoft Office Access database engine cannot find the input table or query 'mdb.newdailydropqry_crosstab'. Make sure it exists and that its name is spelled correctly.

He gets this error even though the query is named correctly and can be accessed independently.

This only happens after the original query is setup and the user needs to update the query or if he happens to delete the query and tries to include a different one. The only way we have been able to get around it is to reset his profile then he can set it up just fine. But after 4 or 5 days the error re-appears. It is not isolated to any one query. It happens regardless of what query he tries to add.

Has anyone seen thsi issue in the past or have any clues as to how we can stop it from re-occuring?

Please let me know if you need further information. I am at a loss at this point..Thanks!