After creating the table with all the other records, I've often had good luckReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12243-access-shut-down.html
appending the bad record but leaving out any memo fields from it.
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
"Allen Browne" wrote:
> You can create a new table that contains all the other records.
> It is important not to refer to the bad record in this process.
> The 3rd sympeom in the article explains how:
> Recovering from corruption
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
> "pigtales" wrote in message
> > Access 2003 shuts down when I want to look at record 195. It does not tell
> > me
> > about the error it simply shuts down. This happens in both the tables and
> > the
> > forms for the same record.
>Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12243