JWColby
jwcolby at colbyconsulting.com
Tue Jan 16 13:17:47 CST 2007
Decompile/compile / compact/repair. If that doesn't fix it, then try exporting the object to another database, or even to text. If that doesn't work, try opening a new database and importing everything into that container. The corrupted object will fail to import to the new container and you will know what it is. In my experience it is usually a form, report or module, but it could be a query I suppose. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Keith Williamson Sent: Tuesday, January 16, 2007 1:55 PM To: Access Developers discussion and problem solving Subject: [AccessD] OMG!!!!!! I have been going through my database application....streamlining....and converting to pulling data from linked tables, to the backend of our SQL database accounting system. During the process, I have been deleting a lot of old tables......that I originally created for downloading data from the application. Since, in most cases, I am now linked directly to the sources tables....I don't need the downloaded data. I was just about to start on the last conversion.......and when I click on the source query (for a LOT of other activity for this particular series of add'l queries/forms/reports.......it immediately kills Access. I mean IMMEDIATELY. I am just clicking on the query, and then clicking the "Design" button. Access instantly closes!! I can only imagine it must have something to do with one of the source tables no longer existing, or something. BUT...how am I supposed to edit this (not to mention even use this query for all the functions it is needed for) if it kills my access? Anyone run across this before? I've already run "Compact and Repair Database" to no avail. Stumped. Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland 21231-3305 410-537-6098 direct | 410-276-2136 fax | www.rtkl.com <http://www.rtkl.com/> -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com