Results 1 to 3 of 3
  1. #1
    lovelykid23 is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Feb 2017
    Posts
    5

    Multiple users editing one file at once

    Hi guys,



    I have an Access database built for a hotline system. I want to put the file on an internal shared network so everyone can access the file. However, sometimes, when more than one person answers the phone at once, the file will be opened and edited by more than one user. I tried splitting the database and only shared the front end (including a form to input data) to the other users. However, when more than one person opened the front end file, there was still an error message popped up saying that another user was opening the file and all the edits might not be saved. There are only 10 people in the network so we don't want to purchase any other network. Is there anyway I can make it work for everyone in the network?
    Thank you very much.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    you DONT share the front end. you share the backend.
    Every person gets their own copy of the front end. This way there are no conflicts.

  3. #3
    lovelykid23 is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Feb 2017
    Posts
    5
    Yes. I was an idiot. I shared and set up the front end for everyone's computer like you said and it worked perfectly fine.
    Thank you very much.

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

Similar Threads

  1. Replies: 2
    Last Post: 11-03-2014, 02:36 PM
  2. Replies: 2
    Last Post: 05-24-2014, 09:47 AM
  3. Replies: 4
    Last Post: 07-10-2013, 08:00 AM
  4. Replies: 3
    Last Post: 09-07-2012, 12:50 PM
  5. Errors with Access file for multiple users
    By Monterey_Manzer in forum Access
    Replies: 3
    Last Post: 06-20-2012, 03:44 PM

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