Strange characters in Access 2003/2007 row

I have a Visual Basic 6 application connected to an Access 2003 database and, sometimes, when I save a register, strange characters appear in the row of the database.

The characters are like this: Žþ or C2051, and only appear in the text fields.

Any suggestions?
ReaL10Asked:
Who is Participating?
 
BrianVSoftCommented:
You should also have a look at this question.. He also had language pack problems in Access & strange characters..
Link is..
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_24275856.html

His final comment below might give you an idea..

Dear mdougan,
I think I found the solution finally, here is what I did:
I checked the regional settings of the 2 computers, and found some differences:

    * From Languages TAB, then click [Details] button, then select Settings tab and in Installed services select Arabic (Egypt) from the drop down list and select code page 102
    * In Languages tab select Arabic (Egypt) from the drop down list of languages for non-unicode programs
    * In the same tab check the following code pages (10004 MAC Arabic / 708 Arabic-ASMO / 864 OEM Arabic) and it worked OK
0
 
puppydogbuddyCommented:
What is the nature of your application?  Are you importing or exporting CSV files that contain unicode characters?

Strange characters in memo fields could be a symtom of corruption-  see this link:
          http://allenbrowne.com/ser-47.html
0
 
ReaL10Author Commented:
No, I don't import nothing in this table.

This table have the lines of the sales order, and I have a form to enter the information in the application.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
hesCommented:
Are you getting extra data from some type of scanner in the sales data.
0
 
ReaL10Author Commented:
No, I have a simple form with head data and lines data ot sales order, and usually works all right, but sometimes appear this characters in the table of the database.
0
 
hesCommented:
Where does the sales data come from ?
0
 
ReaL10Author Commented:
Data are manually input by users through the form.
0
 
BrianVSoftCommented:
Sounds like a Unicode problem.. Check that the fields have unicode set to Off..
One trick is to (on a test backup copy) convert the database to Access-97 (Tools menu / Database Utilities) - Then convert that back to 2000 or 2003.. That can fix some things that a "Repair Database" can't.

Also look for and uninstall any "Language packs" that may be installed. We had a rogue pack once that was converting some VB text into German.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.