Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Help: database corruption

Discussion in 'Information Technology' started by Veli Izzet, Oct 28, 2005.

  1. Veli Izzet

    Veli Izzet
    Expand Collapse
    Guest

    Hi all,

    I have a coruupted database because of a problem in one of the memo fields.

    I get: The Microsoft Jet database engine stopped the process because you
    and another user are attempting to change the same data at the same time.

    I am using Access 2003.

    I need quick help.

    Thanks for answers
     
  2. Loading...


  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Re: database corruption

    Veli Izzet wrote:
    > Hi all,
    >
    > I have a coruupted database because of a problem in one of the memo
    > fields.
    > I get: The Microsoft Jet database engine stopped the process because
    > you and another user are attempting to change the same data at the
    > same time.
    > I am using Access 2003.
    >
    > I need quick help.
    >
    > Thanks for answers


    For a start you can take a look at: http://allenbrowne.com/ser-47.html
    scroll down to the memo field corruption area.

    I can also add that you may be able to recover (note always work on a
    copy of your database) if you can open the table and find the odd entries
    and delete the record before and after. For some reason some memo field
    corruptions seem to display the corruption in a good records data.

    I will also suggest that memo fields seem to be subject to more problems
    than text fields in some applications. I suggest using text fields if
    possible. Text fields also take up less room.

    --
    Joseph Meehan

    Dia duit
     
  4. Amy K

    Amy K
    Expand Collapse
    Guest

    Hi,

    We had the same error message, and it caused our data to be mysteriously
    replaced with oriental writing. The cause of the error turned out to be
    write conflicts, i.e. one user has a record open and another user tries to
    make changes. You should then get a warning message that tells you of the
    write conflict and offers options. In my experience it's always better to
    drop the changes and start again.

    You can also cause a write conflict yourself if you have two forms open at
    once that both relate to the same underlying table.

    Another thing that might help is to regularly compact and repair your
    database. Other than that, I'm afraid I don't have a clue!

    Good luck.

    "Veli Izzet" wrote:

    > Hi all,
    >
    > I have a coruupted database because of a problem in one of the memo fields.
    >
    > I get: The Microsoft Jet database engine stopped the process because you
    > and another user are attempting to change the same data at the same time.
    >
    > I am using Access 2003.
    >
    > I need quick help.
    >
    > Thanks for answers
    >
     
  5. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    Veli Izzet <veli.izzet@gmail.com> wrote:

    >I have a coruupted database because of a problem in one of the memo fields.
    >
    >I get: The Microsoft Jet database engine stopped the process because you
    >and another user are attempting to change the same data at the same time.


    See the Damaged records within tables section in the To retrieve your
    data from a Corrupt Microsoft Access MDB page at my website
    http://www.granite.ab.ca/access/corruption/corruptrecords.htm

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     

Share This Page