UNREADABLE TEXT

[Guest]

A record in Access became unreadable with squares and Asian looking fonts.
How can I fix this? It's only one record of the thousands within my database.

 

[Allen Browne]

Sounds like this one record has become corrupt.

If you are unable to merely delete this record, follow the instructions for
the 3rd symptom in:
Recovering from corruption
at:
http://allenbrowne.com/ser-47.html#RowsShowDeleted

 

[Susie DBA [MSFT]]

it's called corruption

you can prevent this by moving to Accesss Data Projects

 

[Tony Toews [MVP]]

it's called corruption

you can prevent this by moving to Accesss Data Projects

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Guest]

I had a similar sort of thing. I mananaged to delete the corrupted record.
However, after another compact/repair or two, I remade the entry (it was in a
table of with sequentially numbered records and I reflexively filled in the
hole). The new entry immediately corrupted to look like the one with the
Asian characters that I'd cleared out a week or two previously. I've cleaned
it up again, and have been cautious not to remake that one entry. What could
cause that?

 

[Susie DBA [MSFT]]

yeah you should move to Access Data Projects; you can use real
datatypes that don't allow unicode characters for example



Access MDB isn't reliable enogh for real world usage

 

[Susie DBA [MSFT]]

Tony

**** you, I never claimed to be an employee of Microsoft.


I care too much about quality to work for an abusive company like MS