Queries blank???

[Don]

Hi All,

I have a strange situation.

I'm using and Access 2000 front end for a SQL database. I
have a number of select queries that are run via a macro
to create reports. The results of these queries are sent
to separate Excel workbooks.

On multiple occasions, the user of these queries has run
the macro, only to get the error: Query must have at least
one destination field. On further investigation, I find
all of the queries are blank. They have a modified date
of 2/20/04. I ran the queries last 2/27/04 and they
worked fine. The macro contains only the 21 "Output to"
actions to run the queries and there are no code modules
set up in this database.

Any thoughts?

Thanks,

DonC

 

[Chris2]

That's a strange one. I personally am not at all certain what it's doing,
but Access 2000 has done many inexplicable things while I've been working
with it, so you have my sympathies.

Did you run compact and repair? How about the Jet Compact utility?
Failing that, load a copy of the backup made before deploying to production,
and get the query code from there.