By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,335 Members | 2,218 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,335 IT Pros & Developers. It's quick & easy.

Unreadable record in Microsoft Access tables

P: 5
Dear all,

I have one database which open in Microsoft Access 2000 fine with smoothly.

But when I try to open one of the table it shows and display unreadable records in with box marks in every fields.

I tried to change the fonts in Arial (English) but in vain.

Can anyone help it out?

You will find the copy of the database

http://www.sahiwala.com/updates/db1.zip

Please this is very urgent

Good Luck.
Oct 15 '07 #1
Share this Question
Share on Google+
9 Replies


Scott Price
Expert 100+
P: 1,384
The simple Arial font does not support the full range of Unicode characters. Try Arial Unicode MS if you suspect that it is only a case of Unicode characters.

Otherwise, you have either corrupted data, encrypted data, or non-text data.

In the case of corruption, unless you have backups, basically you're in trouble :-(
In the case of encryption you are in trouble unless you can decrypt the data.
It's very unlikely to be a case of non-text data, but who knows?

Regards,
Scott
Oct 15 '07 #2

P: 5
Dear Scott,

I have appreciate of your reply.

I have couple of backups but all are identical same.

I have also tried to append the records in Arial (English).

it seems that new records also appears in nonenglish.

You may also check in the copy of the database

Please see to it.

Best Regards
Oct 15 '07 #3

Scott Price
Expert 100+
P: 1,384
Do you know what language it should display in? Changing the font to WP ArabicScript Sihafa displays something, but since I can't read ArabicScript, I have no idea if that's what you want or not!

Where is the data coming from, and how do you want it to display?

Regards,
Scott
Oct 15 '07 #4

P: 5
Dear Scott,

The data is in English version,

One of our friends has suggessted that you may have open the copy of the database in Russian language system.

You need to have arial cycrllic fonts

but i do not have it.

do you have


Best Regards
Oct 15 '07 #5

Expert 100+
P: 344
Dear Scott,

The data is in English version,

One of our friends has suggessted that you may have open the copy of the database in Russian language system.

You need to have arial cycrllic fonts

but i do not have it.

do you have


Best Regards
I exported the table to excel spreadsheet and at least the fieldnames were now in English, the 1st two columns true/false but the rest was weird symbols. If you are using an unusual font you might get away with exporting the table to excel. Delete it and create a new clean table from an excel import.
Oct 15 '07 #6

Scott Price
Expert 100+
P: 1,384
What language is the data in before you import it? What font is it in?

Changing the format to Arial Unicode MS displays the column headings in English, but the rest of the data in gibberish.

I need to know a lot more information before proceeding. Please answer each question that I have asked before we go any further.

Regards,
Scott
Oct 15 '07 #7

P: 5
Dear Friends,

This is the site

http://support.microsoft.com/kb/237363

But again I need Arial Cycrillic Fonts

Can anyone help it out?

Best Regards
Oct 19 '07 #8

Scott Price
Expert 100+
P: 1,384
Google is your friend :-)

Doing a search using google for "Arial Cyrillic Font" brings up several sites that claim to sell such a thing.

Regards,
Scott
Oct 19 '07 #9

P: 5
Dear Scott,

Thanks for the reply.

I have couple of search and purchase from one vendor.

But however could not achieved. he said you need to have install Windows NT (Russian language) ver 4.0 for that.

phew it is too tired just to fix up the job.

But I will try for the best hope.

haha

Best Regards
Oct 23 '07 #10

Post your reply

Sign in to post your reply or Sign up for a free account.