Results 1 to 6 of 6
  1. #1
    Join Date
    May 2006
    Posts
    386

    Red face Unanswered: Extremely unbelievable. Records of employees with the firstname the same have changed

    Dear All,
    I am under extreme pressure by my boss to fix this. Bascially, somehow where the names of employees on the database is the same, some of their records have changed. Below is the secnario and what has changed.

    Where we had two Anna with the same first name, the following records ave changed.

    1. Surnames have become one surname
    2- Mobile number has changed
    3- Email address have changed

    Basically, one Anna's natinoality was Russian and another Anna was Spanish ,they both now appear as Russian.

    I have not changed anything on the database and was hoping to get some help please.

    Any response would be much appreciated.
    Emi-UK
    Love begets Love, Help Begets Help

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Someone ran an update statement. There may be no fix other than to pull the "correct" information from a backup.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    check the application to see if there is a rogue update statement BEFORE restoring the db, just in case it runs again
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    May 2006
    Posts
    386
    Thank you for your swift response.
    I do not think anyone might have run anything else other than the daily use. However, can you please advise what do you mean by update statement? do you mean someone might have opened the Db in design view and done something?

    Hi to you as well Healdem,

    Where and how can I find this rogue statement. Thank you very much for your support on this.
    Emi-UK
    Love begets Love, Help Begets Help

  5. #5
    Join Date
    May 2006
    Posts
    386
    anyone could help please? I could not think of anything that might have been changed on the database which could have created this problem.
    Emi-UK
    Love begets Love, Help Begets Help

  6. #6
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Then stop looking at the database and look a little closer at the people.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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