Results 1 to 5 of 5

Access not opening in a multi user environment

  1. #1
    Lakecanters is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Oct 2014
    Posts
    5

    Question Access not opening in a multi user environment


    I have an Access Application built with two users on separate desktops. each has a copy of the app on their desktop with a single back end (split) database containing the tables in a separate folder on the first (host) PC. I have had no problem with this until last week. Now, the host PC works fine, but the second PC returns the message "The microsoft Access database engine cannot open or write to the file (back end database name & location). It is already opened exclusively by another user or you need permission to view or write its data". Nothing has changed to my knowledge. But this seems to indicate to me that the host PC is somehow in exclusive mode. Is there a setting I am missing in Microsoft or Access securities? Is there a new setting in forms? I am Stumped. Help! lakecanters1@gmail.com

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,896
    Those issues can also be caused by the OS. Is it ac2013 on both machines? Can you make sure they both have full access to the BE path and can read, wride and delete files in that folder? When both machines are logged off, is the lock file deleted?
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  3. #3
    llkhoutx is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    Check Access Options>>ClientSettings>>Client Settins>>Srcoll down to Advanced section, "No locks" should be selected.

  4. #4
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    7,569
    or the person on the host machine has opened a table in the backend in design view

  5. #5
    Lakecanters is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Oct 2014
    Posts
    5
    Thanks. I will try this tomorrow. Yes, ac2013 is on both machines. I will let you know what I find.

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

Similar Threads

  1. Import Access Database into Excel in Multi-User Environment
    By Chim20 in forum Import/Export Data
    Replies: 7
    Last Post: 10-06-2016, 02:23 PM
  2. Replies: 1
    Last Post: 03-24-2015, 01:49 PM
  3. Replies: 3
    Last Post: 06-14-2012, 08:10 AM
  4. Record Locking Multi User Environment
    By praetorianprefect in forum Database Design
    Replies: 5
    Last Post: 04-16-2012, 02:31 PM
  5. Replies: 13
    Last Post: 05-18-2010, 01:12 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
  •  
Tech Forums: Microsoft Office Forums