[AccessD] OMG!!!!!!

Seems like you have a corrupted query there. Try to delete it and
recreate it or reimport from a backup copy, you do have a backup copy
of the database right??? ;-)

You may have to create an entirely NEW database and import things into
the new database.

You could also try a reboot before you go too far. Sometimes that
works. Sometimes.

GK

On 1/16/07, Keith Williamson <Kwilliamson at rtkl.com> wrote:
> 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
>


-- 
Gary Kjos
garykjos at gmail.com