Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Posts
    1

    multiple user database on a network


    I havent tried this before but i want to come up with a project that will run on a LAN.

    How do i setup a database that runs on a network with multiple users? Do i have to place the database in a shared folder for all to be able to access if. if so how do I make sure that they can all update/open the database at the same time, or they will there be no restrictions?

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    Generally speaking, for most apps, you would split the app into two distinct components:

    1) A 'backend' mdb with all of your tables and
    2) A 'frontend' mdb with all of your forms, queries, reports, macros, and VBA code

    The backend would be on a shared network resource.

    Each user should have his/her own distinct frontend instance; these frontends should either be installed on each user's machine, or deployed on a shared network resource that the user access's via 'remote control' such as Citrix, Windows Terminal, or pcAnywhere.

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

Similar Threads

  1. New Access User
    By Mermaid in forum Access
    Replies: 0
    Last Post: 11-07-2008, 02:28 PM
  2. Replies: 0
    Last Post: 08-20-2008, 10:14 PM
  3. New Database - New User
    By mcarrigg in forum Database Design
    Replies: 1
    Last Post: 06-21-2008, 04:56 PM
  4. Multiple users accessing same database
    By 4ACE in forum Access
    Replies: 0
    Last Post: 02-28-2008, 03:10 PM
  5. Replies: 0
    Last Post: 05-24-2006, 09:26 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