unable to delete row

[Mr Major Thorburn]

We have a table with a row that has bad characters in it
that is stopping us delete the record.
The characters we can see are small squares.
There are no key fields defined for the table.
We are able to add, modify and delete other rows
but not this one.

Any ideas how we can remove this row?

Please help if you can.

Regards Major.
nb thats my Christian name

 

[Colin]

I would suggest that you create a copy of your table and
then paste it withot the data.

Then copy the data from your original table less the one
row when you have done this rename the table to that of
the original

rgds

Colin

 

[Arvin Meyer]

That row, or at least some of the data in it, is undoubtedly corrupt. When
dealing with corruption it is necessary to always work on a copy of the file
so that you have a backup of unchanged data. Working on the original may
make it impossible for a repair service to fix it.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Joseph Meehan]

We have a table with a row that has bad characters in it
that is stopping us delete the record.
The characters we can see are small squares.
There are no key fields defined for the table.
We are able to add, modify and delete other rows
but not this one.

Any ideas how we can remove this row?

Please help if you can.

Regards Major.
nb thats my Christian name

Just a question. Does that record (row) have a memo field and is that
the field that shows up strange?