Results 1 to 2 of 2
  1. #1
    JMac is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2012

    Multiple Users

    I have completed a database which will be placed on a server with a dozen or so users.

    In the event that 2 people access it at the same time and both try to create a new record... how does it cope with this?
    Ideally I would like only one person using it at one time to prevent conflicts or duplicate records??

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    Although an all-in-one db can function with multiple users (I have one small project like that), most advanced developers will recommend splitting the db.

    How to attach file: To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. multiple users
    By slimjen in forum Security
    Replies: 8
    Last Post: 02-09-2012, 10:50 PM
  2. Multiple Users :)
    By greatfallz in forum Access
    Replies: 1
    Last Post: 08-21-2011, 02:40 PM
  3. Multiple Users
    By jo15765 in forum Forms
    Replies: 2
    Last Post: 12-03-2010, 09:51 PM
  4. Multiple Users
    By Nettie in forum Access
    Replies: 5
    Last Post: 10-15-2010, 02:47 PM
  5. How to have multiple users
    By Eric1066 in forum Access
    Replies: 5
    Last Post: 11-19-2009, 05:14 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