Reserved error (-1524); there is no message for this error.

[adampierce]

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.

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.

Any thoughts?

Thanks!

 

[G. Vaught]

If you use the word FALSE they must be enclosed in single quotes as this is
a seen as text to Access. Try using the value 0 (False) or -1 (True) rather
than text True or False. I am assuming that each of these fields are Yes/No
fields and are either checked or unchecked. If they are text fields, then my
first sentence applies.

 

[adampierce]

These are "Yes/No" type fields, not text fields, so True and False
don't have to be in quotes. I went ahead and changed False to 0 and
True to -1 and I'm still getting the same error message.

Thanks for trying!

 

[George Nicholson]

The parentheses look a little odd to me. This probably won't make any
difference but you might try modifying to:

WHERE ((E_CURRENT_DATA.Volunteer = 0) AND
(E_CURRENT_DATA.Absent = 0) AND
(E_CURRENT_DATA.Duplicate = 0))

Also, make sure there's a space after each AND.