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.

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" <(E-Mail Removed)> wrote in message
news:0AFCF282-3CFE-4F88-9848-(E-Mail Removed)...
> 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.

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.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "pigtales" <(E-Mail Removed)> wrote in message
> news:0AFCF282-3CFE-4F88-9848-(E-Mail Removed)...
> > 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.
>
>
>

a 'bad record'

LOL

what a piece of crap database engine you have.

SQL Server doesn't get 'bad records'

grow some balls and stop using an obsolete database





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" <(E-Mail Removed)> wrote in message
> news:0AFCF282-3CFE-4F88-9848-(E-Mail Removed)...
> > 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.