Strange characters in Access 2003/2007 row

Posted on 2009-04-18
Last Modified: 2012-05-06
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?
Question by:ReaL10
    LVL 38

    Assisted Solution

    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:

    Author Comment

    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.
    LVL 24

    Expert Comment

    Are you getting extra data from some type of scanner in the sales data.

    Author Comment

    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.
    LVL 24

    Expert Comment

    Where does the sales data come from ?

    Author Comment

    Data are manually input by users through the form.
    LVL 5

    Expert Comment

    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.
    LVL 5

    Accepted Solution

    You should also have a look at this question.. He also had language pack problems in Access & strange characters..
    Link is..

    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now