My table is an external table (an excel file). It might be that it was modified, or rather copied from another version for instance, so that "for a while", the external table refered to a file that did not exist... But I thought the query would just memorise the SQL code. May be it is safer to save the sql code as a txt file too ? Thank you will check this point with test files
Gilbert Clauss -----Message d'origine----- De : [email protected] [mailto:[EMAIL PROTECTED] De la part de Dawn Crosier Envoyé : jeudi 3 août 2006 19:05 À : [email protected] Objet : RE: [ms_access] self destructing query ? It sounds to me that you may have deleted a table or query which was used to support these queries. Can you restore from a backup? Dawn Crosier "Education Lasts a Lifetime" This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn as well. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Clauss Gilbert Sent: Thursday, August 03, 2006 6:40 AM To: [email protected] Subject: RE: [ms_access] self destructing query ? The grid has become empty ! My queries were quite complicated (with subqueries etc), not easy to rebuild by just draging field names. What is strange is that i executed the queries but did not open them in design view. I really have no idea of what happened (the same happened on 20 different queries, probably after having executing them toward an excel file as output... GC Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
