Saving Queries Issue

[Jerry8989]

When I try and save an older query my entire access shuts down without warning. I tried "Save" and "Save As". I even tried saving to a different name. Any Ideas?

 

[FoFa]

Copy/Paste the SQL into a new query, see if that helps.
I suppose you have tried compact/repair already.

 

[Jerry8989]

I've Tried Compact and repair that didn't help. I will try putting it into a new query window and see if it lets me save.

 

[Jerry8989]

I tried putting the code in another query and it still closed out when I saved. When I opened it back up in the query list the new query showed up but completely empty.

 

[Jerry8989]

Fixed it. The query was way too complex. I broke it down and eveything worked fine. Thanks for the help.