Error 3049 when opening append query

[TimPen]

I have an Access 2000 database.
The backend (data) resides on a network drive.

On the front end I have an append query. Occassionally when I run the query I get the run-time error 3049 - Cannot open database 'query name'. It may not be a database that your application recognizes, or the file may be corrupt.

No users are connected to the backend database & I have closed all forms that are bound to a table or query.

Any ideas on how to fix this?

Thanks in advance

 

[TimPen]

If I open the query in design view, and then open it in Datasheet View, it opens correctly!

 

[TheAceMan1]

How are ya TimPen . . .

Don't you think we need to see the culprit SQL?

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]