Results 1 to 3 of 3

Max users on a network drive

  1. #1
    data808 is offline Competent Performer
    Windows 8 Access 2007
    Join Date
    Aug 2012
    Posts
    476

    Max users on a network drive

    I was just wondering how many users Access would be able to handle on a split frontend and backend database? The backend will be on a network drive and the frontend will be installed on each workstation. My database is pretty simple with no relationships if that matters. Also using Win7 and some users will have Office 2010 and others will have 2013. Any help is appreciated. Thanks.

  2. #2
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    That's kind of a loaded question! Well designed database, Fast network, etc...
    The norm is 10 to 20 but even that is not a given.

    HTH

  3. #3
    data808 is offline Competent Performer
    Windows 8 Access 2007
    Join Date
    Aug 2012
    Posts
    476
    What are some of the things that will happen so I know what to look for if the system can't handle all the traffic? I also understand that if this does not work out, I will have to upgrade to a server backend. Is that correct?

    How much users can the server backend handle?

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

Similar Threads

  1. Replies: 1
    Last Post: 03-13-2014, 10:11 AM
  2. Replies: 3
    Last Post: 05-21-2013, 05:48 AM
  3. Error message when mapping network drive
    By dwcolt in forum Programming
    Replies: 5
    Last Post: 05-11-2011, 08:56 AM
  4. Replies: 1
    Last Post: 04-11-2011, 12:34 PM
  5. Output tables to an excel file on a network drive
    By GraemeG in forum Import/Export Data
    Replies: 1
    Last Post: 04-01-2011, 03:06 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
  •  
Tech Forums: Microsoft Office Forums