Question Locked

old access database character encoding issue

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Greetings all,

I have an old access database (probably 97) that I want to retrieve data
from. The database is not created by me. I am guessing that it was
built by Windows 98 and Office 97, the version that supports arabic.

I converted the dbs to access 2003 but the Farsi/Arabic records are
illegible (funny characters). I have installed Office 97 but it's the same
when I open it using access 97.

I am suspecting this is a character-encoding issue. I tried exporting
the data into excel as text and as html and changed the encoding to
various character sets but it didn't work.

I'll appreciate any suggestion.

Thanks
Basir

6 replies

by basir_noutash

I tried converting the dbs as Microsoft suggests but it didn't
work. Strangely out of 4 databases, 2 of them are fine.

by Former member

Microsoft making software and then not testing it through and through. Oh well such as life. :)
Sorry i could not help you more.

Please post back if you have any more problems or questions.
If this information is useful, please mark as helpful. Thanks.

by thumbsup2

If they're not, importing the records out of 97 into 2003 isn't going to be able to recognize SOME of the characters.

by basir_noutash

I thought language pack was mostly for interface. I'll find the
language packs and try that.

Thanks

This discussion is closed to new replies.