weird bug ?

[webcat]

hi,

has anyone seen this problem ?

Access 2003 -

i have many queries in a DB. they work fine, but *sometimes* some of my queries are wiped - when i try to run them they say "query must contain at least one cell" or something..

when i check the query then, its empty!

i have saved out the SQL code into a word doc because this has happened a few times now.. so i just copy and paste the query back in - but this is very inconvenient! what is going on?


any ideas?

thanks

 

[garethl]

i have had similar issues

are they by any chance based on temporary tables

if you have a query that gets data from a temporary table (maybe the table is built by another query then deleted again) then you open it in design view when the temporary table doesn't exist then all the fields in the query will go blank

if you tehn try to run this from design view you will get the error which you are talking about