Query definition missing

[djj55]

Hello,
I have an Access 2002 database that keeps losing query definitions. I have rebuilt the database and did a compact and repair.

Still it will loose query definitions, which gives the error: Query must have at least one destination field.

The query is there but when you open it, it is blank. The SQL says SELECT DISTINCTROW;

This has happened several times. As the users cannot get to the queries (backdoor is locked) I cannot find what is doing this.

Any suggestions?

Thanks


djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!

 

[GKChesterton]

Very strange. I got this through Google -- doesn't seem likely, but then what would?

Article -- Search on the word "vanish."

[purple]If we knew what it was we were doing, it would not be called
research [blue]database development[/blue], would it? [tab]-- Albert Einstein[/purple]​

 

[djj55]

Thank you for the reply.

For anyone doing a search here is how I solved this.:
My manager suggested using MS SQL stored procedure to do the job. We are going to .NET over the next few months so the problem will not occur at that time.

djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!