[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