Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2011
    Posts
    1

    Unanswered: ms access problem :(

    Please help!
    when I open database with ms access 2003 or 2007, access can't read some text. please see this image also.
    Attached Thumbnails Attached Thumbnails 2011-09-29_144449.png  

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Sorry, but what are we supposed to be seeing?
    "access can't read some text"
    really doesn't mean anything, I'm afraid. You'll have to do much better at describing your problem for anyone to help you.

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    994
    Provided Answers: 2
    Looks like a character set problem. I have no idea how to fix that.
    10% of magic is knowing something that no-one else does. The rest is misdirection.

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    I see what you're talking about, now! This is almost assuredly a sign that the Records in question have somehow been corrupted.

    Best advice I can offer is to

    1. Delete the corrupt Records
    2. Make a backup copy of the File
    3. Turn off Name AutoCorrect. It contributes to corruption and slows down performance. In 2003 and older versions go to Tools - Options - General and in later versions go to File (the Office Button) - Options - Current Database, to do this.
    4. Likewise, for the same reason, turn off Compact on Close. Paradoxically, C & R, in and of itself, is a major cause of corruption!
    5. Do a Compile of the File
    6. Do a Compact and Repair
    7. Create a new, blank File
    8. Import all Objects from the old Database into the new File.

    Hopefully this will kill the Gremlins causing the corruption!

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  5. #5
    Join Date
    Oct 2011
    Posts
    5

    repair your access

    Hi,

    There are some Access database recovery tools that may be able to repair your Access database file. Below is a list of them:

    http://www.datanumen.com/aar/compare.htm

    Most of them provide a free demo so you can try first.

    Alan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •