Results 1 to 6 of 6
  1. #1
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496

    Error handling for "The Microsoft Jet database engine stopped"

    Is there a way to handle the error:


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

    on the form I put an error handler on the current form for when the user moves to the next one but because it is corrupted or for whatever reason the error doesn't get detected and the error still pops up with a standard access error.

    I'd like to handle it and I thought the error number was 3197 but I get nothing

    even msgbox err.number doesn't pop up

    any suggestions?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Do you have a split database with a front end on each user machine talking to liked tables in the Backend?
    There are a lot of links on this -- if you search google with the error message.

    Here's one http://www.itjungles.com/the-microso...same-time.html
    For other info:
    see this re transaction processing in access
    see this link



  3. #3
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    Quote Originally Posted by orange View Post
    Do you have a split database with a front end on each user machine talking to liked tables in the Backend?
    There are a lot of links on this -- if you search google with the error message.

    Here's one http://www.itjungles.com/the-microso...same-time.html
    For other info:
    see this re transaction processing in access
    see this link


    Yes. Everyone is using a frontend - the backend is on the server.

    The corruption occurs on a memo field (common corruption error apparently). When the user tries to open the record the error occurs if the field is corrupted on that particular record.

    I want to catch the error and make it so that the database skips (or excludes with a filter) the record in the recordset. So far the user has to exit the program in order to do anything as it locks up in Runtime Access.

  4. #4
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    I've implemented this: http://www.fmsinc.com/microsoftacces...dDatabase.html

    to see if it improves the speed and reduces errors

    not sure what else I can do

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Have you run compact and repair? I've seen many articles and posts re problems with memo fields.

  6. #6
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    Quote Originally Posted by orange View Post
    Have you run compact and repair? I've seen many articles and posts re problems with memo fields.
    Yes but that is after I have an error and I need to fix the database. I want to circumvent the corrupted record until I get around to compacting and repairing the database.

    Yes any characters over 225 being appended to a memo field will give me problems.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 07-14-2014, 10:34 AM
  2. Replies: 4
    Last Post: 05-10-2012, 07:35 AM
  3. Replies: 1
    Last Post: 09-03-2011, 07:01 PM
  4. Replies: 1
    Last Post: 06-23-2010, 10:52 AM
  5. Replies: 1
    Last Post: 03-02-2010, 03:01 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums