Data changes to "?/" in child table

[tdezwaan]

I have two tables in a one-to-many relationship. In one of the fields on the child table I found that the data in two records was changed to "?/". When I query the data these records are still related to the correct records in the parent table. When I try to change "?/" back to the correct data, Access 97 crashes. So I have three questions: 1. Why did my data change into "?/"?, 2. Why is the altered data still related to the original entry? and 3. Why can't I change the data back to the correct value?

Thanks!

tdezwaan

 

[nickjar2]

Sounds like a corrupted db. I get this all the time in Acc 2000. I have been told that it is down to more than user trying to edit the same record. I don't know how true this is, but it seems to tie in with all the probs I have had. Try doing a compact and repair (or just a repair as u r using Acc 97). Always works for me. You should then be able to amend the strange characters.

Nick

 

[Databaseguy]

Hmmm.

I'm guessing Access doesn't recognoze the character. It could be a "non-character", such as backspace, tab, etc, or it could be a non standard character set. Use chr() to check the string. By default, Access only recognizes 1-128. (ASCII) Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy