Dan Waters
df.waters at comcast.net
Mon Nov 5 20:38:32 CST 2012
Yup - probably corruption. I do have a utility that you could use to export all objects to text and then import back. My personal theory is that importing will recreate the objects within the current Access/Windows environment and may be less prone to corruption. Let me know if you'd like a copy. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel Sent: Monday, November 05, 2012 6:05 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] The case of the gutless queries Hi Dan I appreciate your advice. However, in this case, I have error handling in all procedures, and nothing was raised. I should also add that this application has been in use for about 13 years now, and this is the first time this has happened. Thanks. Regards