Access shut down

[Guest]

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.

 

[Allen Browne]

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

 

[Guest]

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.

 

[dbahooker]

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