Jim Dettman
jimdettman at verizon.net
Mon Nov 5 18:06:29 CST 2012
Definitely in the realm of strange that one is... Certainly some form of database corruption. Only thing I can think of is msysobjects got hosed. That's the only thing they would all share in common. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel Sent: Monday, November 05, 2012 05: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