[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.