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

[Database Administrator]

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!

[Database Administrator]

"adampierce" wrote in message
news:f89f4544-0e1e-4140-9b69-4fac8656ae5d@l1g2000hsa.googlegroups.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

[Database Administrator]

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!

[Database Administrator]

"adampierce" wrote in message
news:aaeb503a-2eb1-4808-aeff-ca146b648997@d4g2000prg.googlegroups.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

[Database Administrator]

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.

[Database Administrator]

"adampierce" wrote in message
news:fdf66445-a2ed-4ce3-99f8-f4ca467a61df@i7g2000prf.googlegroups.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

[Database Administrator]

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!

[Database Administrator]

On Jan 3, 3:41 pm, adampierce wrote:
> 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"

[Database Administrator]

On Jan 3, 3:41 pm, adampierce wrote:
> 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"

[Database Administrator]

"adampierce" wrote in message
news:1d3b4f81-6617-4c84-9f1e-70f40462d826@d4g2000prg.googlegroups.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