Re: Saving Query shuts Access down...???
- From: "Wayne Morgan" <comprev_gothroughthenewsgroup@xxxxxxxxxxx>
- Date: Mon, 13 Feb 2006 12:07:23 -0600
Jerry's answer is the most likely; however, I've seen two other scenarios
cause this also.
1) Jet and/or MDAC patches not up to date.
2) While this shouldn't matter, sometimes it does. Remove all UNNEEDED
brackets and parentheses from the query while in SQL view and try to save
the query. By unneeded, for the brackets you can probably remove them from
around any table or field name that does NOT have a space in it; for the
parentheses, Access insists on putting multiple layers of parentheses around
each part of the WHERE clause. Use only those that are needed to maintain
the desired logic.
If none of the above works, try setting the SQL of the query using code. If
that doesn't work, you may at least get a better error message to let you
know what is going on.
Example:
strSQL = "SELECT ..." 'etc
CurrentDb.QueryDefs("MyQuery").SQL = strSQL
--
Wayne Morgan
MS Access MVP
"Monish" <Monish@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9920E8DB-39A3-47DB-A29A-543EA98EAC6D@xxxxxxxxxxxxxxxx
I am seeing my application shut down (although a *.ldb file is still
listed)
when I try to save a query!
I am working in Access 2002, but over the weekend sent my db home to work
there (where I have Access 2003).
Can anyone please let me know why this is happening?
Thanks,
M
.
- Prev by Date: Re: query for multiple results
- Next by Date: Re: Numering records in a group
- Previous by thread: Re: Saving Query shuts Access down...???
- Next by thread: RE: Saving Query shuts Access down...???
- Index(es):
Relevant Pages
|
