Unreadable record in Microsoft Access tables

1,384

Expert 1GB

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

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

1,384

Expert 1GB

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

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

Lysander

344

Expert 100+

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

1,384

Expert 1GB

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

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

1,384

Expert 1GB

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

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

by: Skully Matjas | last post by:

I am using the following code (created by the wizard) to allow to bring my form to a particular entery. But when I edit the entery (ex: put new information into a blank cell), it puts that record...

Access vs. SQL for audit trail of record changes?

by: Jim M | last post by:

I've been playing with Allen Browne's audit code and found it very useful. I need to track record insertions, deletions, and edits for several tables. I am planning to replace Access with Microsoft...

Multiple Record Copy Transaction...

by: davidgordon | last post by:

Hi, I need some pointers/help on how to do the following if it possible: In my access db, I have the following: Tables: Products, Sub-Assembly, Product-Pack Table, Products

How do I add a record to an MS Access database

by: Roy Gourgi | last post by:

Hi, I am using VS.NET 2003 and I have made a connection to a MS Access database using the Server Explorer. Is this connection permanent, meaning that it will be there every time I reopen my...

C# / C Sharp

Searching in detail table to find master record

by: john | last post by:

In my form I have a master table and a details table linked 1xM. I can search through the whole parent table but I also like to be able to search through the child table fields to find parent...

Is it possible to determine the record ID when using INSERT INTO?

by: MLH | last post by:

Suppose, in a multi-user environment, you have append query SQL in a VBA procedure that looks like INSERT INTO MyTable... and the next line reads MyVar=DMax("","MyTable... You can never be...

"Record is too large"?

by: tekctrl | last post by:

Anyone: I have a simple MSAccess DB which was created from an old ASCII flatfile. It works fine except for something that just started happening. I'll enter info in a record, save the record,...

Warn user-2 if user-1 on requested record

by: emanning | last post by:

Using Access 2003 and using a form that's mostly bound. I need a way to tell if user-1 is on the record when user-2 tries to open the same record, w/o waiting for the user-1 to save the record...