corrupt lines in tables

[matthew]

hi all

we have recently updated our computer systems from access
97 to access XP. we have converted our database to 2002
format. Since then we are getting corrupt lines in or
tables as below

CUSTOMER PART NO QTY ORDER NO SHIP DATE
㘰Ｐ揾 慤ｮヾ ⴸ㄰〵ⴳ ㌰Ｐ 〱Ｐ㓾 00:00:00 ㌰Ｖㇾ
〰??㔠

we can find out what the record should and compact and
repair the database and delete the record and re key the
line in ada

 

[Tony Toews]

we have recently updated our computer systems from access
97 to access XP. we have converted our database to 2002
format. Since then we are getting corrupt lines in or
tables as below

CUSTOMER PART NO QTY ORDER NO SHIP DATE
㘰Ｐ揾 慤ｮヾ ⴸ㄰〵ⴳ ㌰Ｐ 〱Ｐ㓾 00:00:00 ㌰Ｖㇾ
〰??㔠

we can find out what the record should and compact and
repair the database and delete the record and re key the
line in ada

1) Have you investigated the OpLocks problem to see if that may be the
cause? One of the two conditions for which people seem to start
noticing this problem is after converting from A97 to A2000 or newer.
See the Corruptions FAQ page at my website.

2) To delete specific records see the Damaged records within tables
section in the To retrieve your data from a Corrupt Microsoft Access
MDB page at my website
http://www.granite.ab.ca/access/corruptmdbretrievedata.htm#DamagedRecords

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm