Results 1 to 9 of 9
  1. #1
    ravininave is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2015
    Posts
    11

    The Microsoft Office Access database engine stopped the process because you and another user are att

    Hi, I'm getting error like


    "The Microsoft Office Access database engine stopped the process because you and another user are attempting to change the same data at the same time"
    I'm not able to open the database. Even I can't import/export data to another db or from another db. I tried with several compact utility (downloaded jetcomp.exe) but it didn't works.
    I tried mostly solutions from web.

    Can anyone tell me the perfect solution for this.?

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    trying rebooting your computer?

  3. #3
    ravininave is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2015
    Posts
    11
    I'm trying this from last 8-10 days means I had rebooted my pc at least 10-20 times.

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Is this a multi user db with front ends on each users machine and backend on the network? Or a single, non split db? If split is the front end shared (i.e. on the network)? Also what version is everyone using? 2007? runtime? 32 or 64bit? If split is it the front end or backend which you do not have access to?

    If multi user, perhaps someone else is connected to the db? Open the .laccdb file and see how many connections exist. Also try deleting this file.

    Have you tried opening the file from another computer? perhaps your copy of Access is corrupted?

    I suspect jetcomp wouldn't work - JET is the old, ACE is the new from 2007

  5. #5
    ravininave is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2015
    Posts
    11
    Yes it's a 2007 version. No I'm not using it in Network it's on standalone pc. non split db. 32 bit. not multi user single user. I tried it on my another pc and on laptop everywhere I am getting same error.
    I didn't tried ACE. It it a recovery tool?

  6. #6
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    ACE is the database engine - previously Access used JET.

    Only other thing I can suggest it to try and open the db in exclusive mode. Open access, browse to your file and in the bottom right, select the exclusive option.

    Otherwise, sounds like your db is corrupted, can you revert to a backup? if not I think you have a problem. Once you do get up and running again, I strongly recommend you split the db, keep a spare copy of the frontend somewhere and regularly backup the backend - it reduces the chances of corruption and improves the opportunity to recover, even for single users.

  7. #7
    ravininave is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2015
    Posts
    11
    Quote Originally Posted by Ajax View Post
    ACE is the database engine - previously Access used JET.

    Only other thing I can suggest it to try and open the db in exclusive mode. Open access, browse to your file and in the bottom right, select the exclusive option.

    Otherwise, sounds like your db is corrupted, can you revert to a backup? if not I think you have a problem. Once you do get up and running again, I strongly recommend you split the db, keep a spare copy of the frontend somewhere and regularly backup the backend - it reduces the chances of corruption and improves the opportunity to recover, even for single users.

    Still no one is telling me how to repair the db.

  8. #8
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    if it is corrupted, it cannot be repaired

  9. #9
    ravininave is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2015
    Posts
    11
    Okay Ajax. Thanking you!

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

Similar Threads

  1. Replies: 24
    Last Post: 07-08-2013, 12:59 PM
  2. Replies: 4
    Last Post: 05-10-2012, 07:35 AM
  3. Replies: 6
    Last Post: 10-30-2010, 08:42 AM
  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