Access Crashes when trying to save a Query

[Miguel]

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

 

[david epsom dot com dot au]

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)

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.

 

[Tim Ferguson]

All Access 2K databases are unstable :~)

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