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

[a_p_messner]

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 setup is very
simple.

Any thoughts?

 

[a_p_messner]

I should note that I ran the "compact and repair database" tool and I am
still getting the same error message. Thanks!

 

[a_p_messner]

Just in case this helps...here is the SQL for the query I am trying to run:

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 the WHERE clause out, it works, but that's no good
to me, because I need to filter on the fields contained in the WHERE clause.

Thanks!

 

[a_p_messner]

I think I got an answer on another newsgroup...It looks like there was
corrupt data in the table being queried. As soon as I isolated and removed
the corrupt data, the query worked.