John Bartow
john at winhaven.net
Tue Jan 16 15:04:40 CST 2007
OK - in your mind just picture me doing it for you ;o) (Since I've probably had to doit a gazillion times in the last year!) whoosh! -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Keith Williamson Sent: Tuesday, January 16, 2007 3:04 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] OMG!!!!!! ROFLOL!!! I can't do that dance, yet. I'm still in my 6-month evaluation period, here at work. If I did that dance.......I'd probably wind up bounced out on the street. :))) 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 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow Sent: Tuesday, January 16, 2007 3:46 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] OMG!!!!!! unfortunately, that sounds very familiar! 1. Decompile - I keep a shortcut on hand at all time: "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /decompile 2. compact and repair 3. compile 4. compact and repair 5. throw hands up in the air 6. stand up 7. go whoosh! (and pretend your doing the wave at a big stadium) 8. when people around you think that's weird - explain to them that Microsoft had produced MS Access for over 10 years now and stills allows it to corrupt itself on a regular basis. They're well a respected company, so how can me, doing the wave in my office after overcoming their mistakes with an undocumented startup switch be weird?! -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Keith Williamson Sent: Tuesday, January 16, 2007 12: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. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com