I am trying to run a pretty simple select query in Access 2007, and I
keep getting the error message "Reserved error (-1524); there is no
message for this error." There are no linked tables in the database -
the design of the database is very simple.
I should also note that I ran the "compact and repair database" tool
and I am still getting the same error message.
Any thoughts?
Thanks!
"adampierce"
news:f89f4544-0e1e-4140-9b69-4fac8656ae5d@l1g2000hsa.googleg roups.com...
>I am trying to run a pretty simple select query in Access 2007, and I
> keep getting the error message "Reserved error (-1524); there is no
> message for this error." There are no linked tables in the database -
> the design of the database is very simple.
>
> I should also note that I ran the "compact and repair database" tool
> and I am still getting the same error message.
>
> Any thoughts?
>
> Thanks!
Just a guess.....
Do you have any field names that use "reserved" words?
Like:
Date, Name, Min, Max, Sum, Where, etc
Would you post the query?
Fred Zuckerman
I don't think I'm using any reserved words...Here is the SQL:
SELECT E_CURRENT_DATA.Prefix, E_CURRENT_DATA.LastName,
E_CURRENT_DATA.FirstName, E_CURRENT_DATA.Address, E_CURRENT_DATA.City,
E_CURRENT_DATA.ZIP
FROM E_CURRENT_DATA
WHERE (((E_CURRENT_DATA.Volunteer)=False) AND
((E_CURRENT_DATA.Absent)=False) AND
((E_CURRENT_DATA.Duplicate)=False))
ORDER BY E_CURRENT_DATA.LastName, E_CURRENT_DATA.FirstName;
I noticed that if I take out the "Where" clause, it works, but that's
no good to me, because I need to filter the data on these fields.
Thanks!
"adampierce"
news:aaeb503a-2eb1-4808-aeff-ca146b648997@d4g2000prg.googleg roups.com...
>I don't think I'm using any reserved words...Here is the SQL:
>
> SELECT E_CURRENT_DATA.Prefix, E_CURRENT_DATA.LastName,
> E_CURRENT_DATA.FirstName, E_CURRENT_DATA.Address, E_CURRENT_DATA.City,
> E_CURRENT_DATA.ZIP
> FROM E_CURRENT_DATA
> WHERE (((E_CURRENT_DATA.Volunteer)=False) AND
> ((E_CURRENT_DATA.Absent)=False) AND
> ((E_CURRENT_DATA.Duplicate)=False))
> ORDER BY E_CURRENT_DATA.LastName, E_CURRENT_DATA.FirstName;
>
> I noticed that if I take out the "Where" clause, it works, but that's
> no good to me, because I need to filter the data on these fields.
>
> Thanks!
It works for me (A2K on WXP).
Are you sure that the fields [Volunteer], [Absent], [Duplicate] are of the
yes/no type?
You might try removing the where clause by one field at a time, maybe just
one of the fields is the problem.
Fred
Yes...They are definitely yes/no fields...I tried removing them one at
a time, and it turns out that if I remove all of them, the query runs,
but if I leave any of them in, it doesn't run. What is possibly even
more odd is that I can filter on these fields in some queries but not
in others. I even have a query where this type of WHERE clause works
when I run the query, but when I try to view it through a report
rather than in datasheet view, I get this same weird error message.
Does it have anything to do with the fact that I'm using Access 2007?
Thanks again for your help.
"adampierce"
news:fdf66445-a2ed-4ce3-99f8-f4ca467a61df@i7g2000prf.googleg roups.com...
> Yes...They are definitely yes/no fields...I tried removing them one at
> a time, and it turns out that if I remove all of them, the query runs,
> but if I leave any of them in, it doesn't run. What is possibly even
> more odd is that I can filter on these fields in some queries but not
> in others. I even have a query where this type of WHERE clause works
> when I run the query, but when I try to view it through a report
> rather than in datasheet view, I get this same weird error message.
>
> Does it have anything to do with the fact that I'm using Access 2007?
>
> Thanks again for your help.
Next guess....
Check your references to see if any show as "Missing"
Ctrl+G, Tools -> References
Otherwise, I'm stumped.
Sorry
Fred
How do I know if a reference is missing? When I look at references, I
get a list of available references, and the first four have check
marks next to them, and the rest are blank. I don't clearly see that
anything is missing, though.
Thanks again!
On Jan 3, 3:41 pm, adampierce
> I don't think I'm using any reserved words...Here is the SQL:
>
> SELECT E_CURRENT_DATA.Prefix, E_CURRENT_DATA.LastName,
> E_CURRENT_DATA.FirstName, E_CURRENT_DATA.Address, E_CURRENT_DATA.City,
> E_CURRENT_DATA.ZIP
> FROM E_CURRENT_DATA
> WHERE (((E_CURRENT_DATA.Volunteer)=False) AND
> ((E_CURRENT_DATA.Absent)=False) AND
> ((E_CURRENT_DATA.Duplicate)=False))
> ORDER BY E_CURRENT_DATA.LastName, E_CURRENT_DATA.FirstName;
>
> I noticed that if I take out the "Where" clause, it works, but that's
> no good to me, because I need to filter the data on these fields.
>
> Thanks!
Have you tried simplifying the query and the WHERE clause as much as
possible? EG
"SELECT Prefix, LastName, FirstName,
Address, City, ZIP
FROM E_CURRENT_DATA
WHERE NOT (Volunteer Or Absent Or Duplicate)
ORDER BY LastName, FirstName"
On Jan 3, 3:41 pm, adampierce
> I don't think I'm using any reserved words...Here is the SQL:
>
> SELECT E_CURRENT_DATA.Prefix, E_CURRENT_DATA.LastName,
> E_CURRENT_DATA.FirstName, E_CURRENT_DATA.Address, E_CURRENT_DATA.City,
> E_CURRENT_DATA.ZIP
> FROM E_CURRENT_DATA
> WHERE (((E_CURRENT_DATA.Volunteer)=False) AND
> ((E_CURRENT_DATA.Absent)=False) AND
> ((E_CURRENT_DATA.Duplicate)=False))
> ORDER BY E_CURRENT_DATA.LastName, E_CURRENT_DATA.FirstName;
>
> I noticed that if I take out the "Where" clause, it works, but that's
> no good to me, because I need to filter the data on these fields.
>
> Thanks!
Have you tried simplifying the query and the WHERE clause as much as
possible? EG
"SELECT Prefix, LastName, FirstName,
Address, City, ZIP
FROM E_CURRENT_DATA
WHERE NOT (Volunteer Or Absent Or Duplicate)
ORDER BY LastName, FirstName"
"adampierce"
news:1d3b4f81-6617-4c84-9f1e-70f40462d826@d4g2000prg.googleg roups.com...
> How do I know if a reference is missing? When I look at references, I
> get a list of available references, and the first four have check
> marks next to them, and the rest are blank. I don't clearly see that
> anything is missing, though.
>
> Thanks again!
If there was a problem, then one of the checked items would have the word
"Missing" next to it.
Fred
"Fred Zuckerman"
news:GEcfj.3912$lo5.1280@newssvr19.news.prodigy.net...
> "adampierce"
> news:1d3b4f81-6617-4c84-9f1e-70f40462d826@d4g2000prg.googleg roups.com...
>> How do I know if a reference is missing? When I look at references, I
>> get a list of available references, and the first four have check
>> marks next to them, and the rest are blank. I don't clearly see that
>> anything is missing, though.
>>
>> Thanks again!
>
> If there was a problem, then one of the checked items would have the word
> "Missing" next to it.
> Fred
Maybe there's a corrupted record somewhere in the table. Try deleting all
the records and run the query on the empty table. If you don't get the
error, then add back some records, and repeat.
Fred
I think you hit it right on the head. I found a record that had some
corrupt data in it, and when I deleted it, the query worked! Thanks!
adampierce
>I think you hit it right on the head. I found a record that had some
>corrupt data in it, and when I deleted it, the query worked! Thanks!
Thanks for posting back your solution. That message is exceedingly rare when I did
some searching at Google. I'd suggest purchasing some lottery tickets.
Added to the Access Corruption Symptoms page at my website.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/