Access Crashes when trying to save a Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have one specific query which causes Access (2K) to crash whenever I attempt to save it (even if no changes have been made). I am able to save other queries without a problem. I tried copying the SQL statements into a new query, but the problem followed. I suspect the database itself is unstable as I sometimes have similar problems with reports

Has anyone experienced a similar problem. If so I would appreciate knowing how you resolved it

TIA
Miguel
 
Last time I had this, I resolved the problem by
1) Saving a simpler query
2) Changing the simple query by adding the extra table and fields.
3) Saving the modified query.

All Access 2K databases are unstable :~)

(david)

Miguel said:
I have one specific query which causes Access (2K) to crash whenever I
Click to expand...
attempt to save it (even if no changes have been made). I am able to save
other queries without a problem. I tried copying the SQL statements into a
new query, but the problem followed. I suspect the database itself is
unstable as I sometimes have similar problems with reports.
 
All Access 2K databases are unstable :~)
Click to expand...

Well that is clearly untrue, but there are things you can do to destabilise
a Jet file:

- Use it across a network that is not 100% reliable;

- Share it between multiple users;

- Over-enthusiastic compacting/ repairing;

- Lots of object creation/ editing/ deletions without compacting
and repairing;

The first two are far and away the best ways to corrupt an mdb.

B Wishes


Tim F
 
Back
Top