Access shut down

#1 (**permalink**) 28-Jul-2006, 08:27 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12243-access-shut-down.html
forms for the same record.

*

#2 (**permalink**) 28-Jul-2006, 08:27 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12243
> me
> about the error it simply shuts down. This happens in both the tables and
> the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12243
> forms for the same record.

#3 (**permalink**) 28-Jul-2006, 08:27 AM

After creating the table with all the other records, I've often had good luck
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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12243
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "pigtales" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12243
> 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.
>
>
>