Design View chrash

  • Thread starter Thread starter jkochchs
  • Start date Start date
J

jkochchs

Hi,

I have a query that I've used forever, it is still working
fine, it was created through design view.

The query continues to work fine, I can access SQL view
but access crashes when trying to open the query in design
view.

Any words of wisdom what might be wrong?

Other than the database continueing to be enhanced with
data, there have not been any substantial changed to the
db design or environment.

Thanks in advance..... jkochchs
 
Hello,

Looks like query is corrupted. Tyr the compact/repairing the database. If
this doesn't help, create a new blank database and import
all the objects (tables, queries, etc) from original database. It this
fails then just create a new query by copy/pasting SQL statements.

If above doesn't help, copy just potion of the SQL statement until it fails.

Hope this helps!

Ki
 
Back
Top