[AccessD] The case of the gutless queries

Wow ! Of course, a backup of the FE is all that is needed.
On top of that, I export all of the SQL from each of the queries and place it 
into a large text file.

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-
> bounces at databaseadvisors.com] On Behalf Of Steve Schapel
> Sent: Monday, November 05, 2012 5:20 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] The case of the gutless queries
>
> I have just come across a weird one!
>
> Easy to fix - I just have to replace the frontend file.  But can think
> of no explanation.  Anyone ever seen anything like this?...
>
> Access 2003 MDE, with mdb backend on network server.  Got a call from
> the client to say that he was entering data, when suddenly it stopped
> working.  No error apparently.
>
> On investigation, this is what I found....  All the queries were empty!
> I mean blank - not talking data here, I am talking design view of
> queries with nothing there, and SQL view saying only "SELECT;"  All of
> them ... ppfffft!
>
> Just for interest, any thoughts?
>
> Regards
> Steve
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com