After creating the table with all the other records, I've often had good luck
Reference:: 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.
--
Jerry Whittle
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
> at:
> http://allenbrowne.com/ser-47.html
>
> --
> 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
> news:0AFCF282-3CFE-4F88-9848-2D2B678812EB@microsoft.com...
> > 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