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" <apmessner (AT) gmail (DOT) com> wrote

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" <apmessner (AT) gmail (DOT) com> wrote

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" <apmessner (AT) gmail (DOT) com> wrote

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 <apmess... (AT) gmail (DOT) com> wrote:
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 <apmess... (AT) gmail (DOT) com> wrote:
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" <apmessner (AT) gmail (DOT) com> wrote

If there was a problem, then one of the checked items would have the word
"Missing" next to it.
Fred