[AccessD] OMG!!!!!!

Any chance you can open it in SQL mode instead? Failing that, what about importing that query into a new database and inspecting it there?

----- Original Message ----
From: Keith Williamson <Kwilliamson at rtkl.com>
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Sent: Tuesday, January 16, 2007 1:54:49 PM
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