No Read Definition

[MooseMan]

I have a number of queries called from a function that creates a temporary table and then populates and runs calculations on the data.

My problem is that after everything working for a number of weeks, the function began to freeze. I discovered after attempting to run each query individually that I receive the following error message on two of the queries. "Cannot read table definitions"

I am the administrator, and the owner of the tables and the queries and everything has worked up to now.

Any ideas on what might have happened and what I can do to resolve this?

I checked all the permissions and I have everything on everything.

Thanks in advance for any help

 

[mp9]

Have you compacted and repaired your DB lately?

http://www22.brinkster.com/accessory/

 

[MooseMan]

The back-end which resides on a server is compacted each night. Would that have any adverse effects?