Glenn Lieding
Registered User.
- Local time
- Yesterday, 18:53
- Joined
- Feb 5, 2013
- Messages
- 11
Access (2013) consistently crashes when using Query Design. I have discovered a workaround:
Always save and close the Query you are editing before running it. Never run it directly from Query Design (the Run! menu item or Datasheet view).
A little bit of a hassle, but a lot better than crashing your whole project!
The one place this doesn't work is if you want to preview the results of an Append Query before actually doing an Append. To do this, you either have to take your chances by peeking at it in Datasheet view, or convert the Append Query back to a Select Query, run it (as above) to see the results, and then convert it back to an Append Query and run it again (as above).
Now this would be great (sort of) if Append Queries always ran with the same results as their corresponding Select Queries. However, I have discovered that that is not always the case. I have posted a separate thread about this issue, "Calculated Field Expressions work in Select Query but not as Append Query" (showthread.php?p=1230863).
I hope this helps somebody, and that somebody can help me with that other problem.
Thanks!
Always save and close the Query you are editing before running it. Never run it directly from Query Design (the Run! menu item or Datasheet view).
A little bit of a hassle, but a lot better than crashing your whole project!
The one place this doesn't work is if you want to preview the results of an Append Query before actually doing an Append. To do this, you either have to take your chances by peeking at it in Datasheet view, or convert the Append Query back to a Select Query, run it (as above) to see the results, and then convert it back to an Append Query and run it again (as above).
Now this would be great (sort of) if Append Queries always ran with the same results as their corresponding Select Queries. However, I have discovered that that is not always the case. I have posted a separate thread about this issue, "Calculated Field Expressions work in Select Query but not as Append Query" (showthread.php?p=1230863).
I hope this helps somebody, and that somebody can help me with that other problem.
Thanks!
