Results 1 to 4 of 4
  1. #1
    neosoma is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2022
    Posts
    2

    Exclamation System down after update with a problem related to the exclusive mode

    Hi all!



    I have a database installed in a hospital, and after one update this 10th juanuary related to the office, one critical problem has arised: All connections are performed in an exclusive mode, emerging 2 problems:
    - Frontends cannot connect with the backend at the same time.
    - We have Crystal Reports connected for the generation of dynamic reporting, and since crystal try to open the backend as well, it cannot do it and reports cannot be generated.

    The structure and features of our system:
    - We have installed the runtime for Office 2016 32bits at the hospital in all the machines. (accessruntime_4288-1001_x86_es-es)
    ------- Note: We are maintaining the 32 version due to compatibility issues related to the connection with crystal reports.
    - We also have installed the access database engine to establish connection with the backend from one .net application: accessdatabaseengine.exe (32 bits)
    - We have 4 computers with the frontend, and the backend in an internal network drive.
    - Both, the backend and the frontends are compiled (accde)

    The errors, are similar like this: "It couldn't connect... the file is already in use".

    We don't understand how this exclusive mode has been activated after this update, and we would like to know if there is some way to force the backend to be accessed in a concurrent/shared mode.
    Doctors are having a critical issue at this time, so I really appreciate any help.

    Note: These installation has been sucessfully working for over 2 years until this moment.

    Thanks!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    We have had to uninstall some office updates.
    this fixed the problem.

  3. #3
    neosoma is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2022
    Posts
    2
    We cannot uninstall any update.
    This update comes from a different organization unit (even from a different location), and they apply the security rules they considere.
    It's quite difficult getting access to them.

  4. #4
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    This is almost certainly a Microsoft introduced bug - see this thread https://www.accessforums.net/showthread.php?t=84999
    and here for solutions
    https://support.microsoft.com/en-us/...0-d079a46f5acc
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

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

Similar Threads

  1. Replies: 3
    Last Post: 05-23-2020, 11:45 AM
  2. Replies: 2
    Last Post: 05-27-2015, 12:59 PM
  3. User only opens DB in Exclusive mode
    By DB88 in forum Access
    Replies: 18
    Last Post: 06-05-2014, 11:24 AM
  4. Replies: 3
    Last Post: 03-22-2014, 04:32 PM
  5. exclusive mode
    By raffie77 in forum Access
    Replies: 7
    Last Post: 01-24-2012, 10:27 PM

Tags for this Thread

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