Results 1 to 4 of 4
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Error message change data (A97)

    When attempting to run a report which has a straight forward query the program comes up with the following error, even though I am the only user:

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

    This also happens in a form when using Ctrl F to do a search, it seems to happens when you start the search.

  2. #2
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Error message change data (A97)

    It usually means that the database has corrupt data, most likely in a memo field. See MSKB Article 182867:

    ACC: Jet Database Engine 3.x Error Messages Due to Corruption

    HTH

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Error message change data (A97)

    Thanks Mark, I will check it out at work tomorrow.

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Error message change data (A97)

    Thanks Mark.

    You were right, it was a corrupt memo field.
    It was simple enough to fix, we had to delete the records concerned after printing them out so we could re-input them.

Posting Permissions

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