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

[Database Administrator]

"Fred Zuckerman" wrote in message
news:GEcfj.3912$lo5.1280@newssvr19.news.prodigy.ne t...
> "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
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

[Database Administrator]

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!

[Database Administrator]

adampierce wrote:

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

[TN_Canada]

I just got this error today and found out that some data in the table were corrupted. Once I try to view the data in the table, it pops that message again, reserve error -1524. Repair the tabled and thing back to normal.

[thr_mhmd]

Hi Guys
I happened to come across the same issue and what worked for me was to create a new database, importa all objects in the new database and work from there.

Regards
Tahir

[mondo3_a]

This can occur if someone enters control characters in a text field. try making a new temporary column and copy/paste the entire suspect column into the new temporary column. if you get an error like "only able to copy 100 of 101 records" you'll know that this is the problem. then you'll have to search the records for the one that has control characters (it should be fairly obvious as it will look like mini squares or symbols).