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.

Any thoughts?

Thanks!

Jan 3 '08 #1

Fred Zuckerman

"adampierce" <ap*******@gmail.comwrote in message
news:f8**********************************@l1g2000h sa.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

Jan 3 '08 #2

adampierce

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.

Jan 3 '08 #3

Fred Zuckerman

"adampierce" <ap*******@gmail.comwrote in message
news:fd**********************************@i7g2000p rf.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

Jan 3 '08 #4

adampierce

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!

Jan 3 '08 #5

Fred Zuckerman

"adampierce" <ap*******@gmail.comwrote in message
news:1d**********************************@d4g2000p rg.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

Jan 3 '08 #6

Fred Zuckerman

"Fred Zuckerman" <Zu********@sbcglobal.netwrote in message
news:GE*****************@newssvr19.news.prodigy.ne t...

"adampierce" <ap*******@gmail.comwrote in message
news:1d**********************************@d4g2000p rg.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

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

Jan 3 '08 #7

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!

Jan 3 '08 #8

Tony Toews [MVP]

adampierce <ap*******@gmail.comwrote:

>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/

Jan 4 '08 #9