Results 1 to 6 of 6
  1. #1
    Eric1066 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2009
    Posts
    14

    How to have multiple users

    Hi,



    My db is almost complete, it is very simple but I would like more than one user on the network to access it and save to it.

    Do I simply put the db on a network drive and have people access it this way or is there something more technical I need to do?

    Thanks. Any Help greatly appreciated!!
    Eric1066

  2. #2
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    For a start you need to split the database between front end and back end. Do a search on this first before you do anything.

    David

  3. #3
    Eric1066 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2009
    Posts
    14
    thankyou so much for your reply, but I am afraid I have no idea what this means. I ran a search as you suggest and only found some very confusing information, I am complete noob at this! can you suggest a site which explains this in a disney like fashion. I appreicate your help!!

  4. #4
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    An Access database comprises of objects, Tables, queries, forms,Etc. In order for more than one person to use it in different locations you need to have a central place where every one has access to, this is normally a shared network server.

    You first create one mdb that just contains the tables, nothing else This is known as the Front End. Then you create a second database that contains everything esle, the forms, queries, reports, macros, etc.

    You then use the Link table manager to link the front end to the back end. Each front end is given to each user who installs it on their client side PCt/Workstation/Laptop.

    Now when the user opens the application on their machine it reads the data form the server, then as they update it other users can see the changes automatically.

    David

  5. #5
    Eric1066 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2009
    Posts
    14
    ok thx for this, one question though, you say that the tables db is the front end and the forms, queries etc... are the back end and it is the front end I install on users pc's, is this right? I ask because I though the data was held on the tables and thought that this must be the back end.

  6. #6
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    Dyslexia rules KO

    You are right I got it the wrong way round for some reason, brain explosion.

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

Similar Threads

  1. Access Locking other users out
    By David in forum Access
    Replies: 1
    Last Post: 07-02-2009, 09:26 PM
  2. Limiting access to certain users only
    By huskies in forum Security
    Replies: 1
    Last Post: 04-01-2009, 08:18 AM
  3. Users on Database Simultaneously
    By rtemple in forum Access
    Replies: 2
    Last Post: 03-26-2009, 08:38 PM
  4. disconnected Remote Users?
    By Zermoth in forum Programming
    Replies: 0
    Last Post: 12-11-2008, 04:52 AM
  5. Multiple users accessing same database
    By 4ACE in forum Access
    Replies: 0
    Last Post: 02-28-2008, 03:10 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