Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2011
    Posts
    20

    Post Multi User Project

    Hi

    I have a Developed a project in access with the multi user login.

    Hence i need to place my project in a shared drive so that registered users use my project simentanously.

    My worry is if all users access my project and entered the data, will it affect or over lap the data???

    Or is it possible to place my project in shared drive to use across multiple users.



    Plz assist

  2. #2
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    675
    I'm not sure I understand.

    Typically if you need to have multiple users in your mdb/accdb, you want to do the following:

    1. Split the mdb/accdb so that your tables are in one mdb/accdb (called a backend) and then link those tables into an mdb/accdb (called a frontend). Using SQL Server tables linked into the frontend is ideal.
    2. For the frontend, I like to then create an mde/accde file for the users to open. This prevents users from seeing the code and usually an mde/accde performs better.
    3. I like to use the vb script found here: https://www.accessforums.net/code-re...sier-7572.html (for frontends only). This script basically copies and pastes a file but it adds the loginID to the pasted file and then opens it. This means everyone is in their own frontend (which is cloned from a 'source' frontend mde/accde). Since any file typically has limitations when it comes to more than 3 simultaneous users, this vb script works nicely and allows you to have hundreds of users using your application without problems.

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

Similar Threads

  1. Replies: 6
    Last Post: 06-02-2011, 12:27 PM
  2. multi-user question
    By Killerbee in forum Forms
    Replies: 8
    Last Post: 05-03-2011, 02:37 PM
  3. Replies: 22
    Last Post: 01-25-2011, 11:19 AM
  4. Replies: 5
    Last Post: 12-19-2010, 04:40 PM
  5. Replies: 13
    Last Post: 05-18-2010, 01:12 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 - Senior Forums