Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2011
    Posts
    2

    Unhappy Unanswered: multiple users of one database

    We have 3 users of a database (Patient) on a LAN. the forms (patientID) take info from:confused tables (diagnoses,procedureType) and enter data from the form to table (visits).
    When one user logs on the database is closed to other users. How do I separate the forms from the tables and relink them so that different users can update info without the other logging off. I am using ACCESS 2007

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    There are several solutions for creating a back-end database (that contains the tables) and a front-end database (that contains the interface to the data (queries, forms, reports, macros, etc.) See for instance (among many others):
    How to manually split a Access database in Microsoft Access
    AMicrosoft Access tips: Split your MDB file into data and application
    Splitting an Access Database, Step by Step
    Splitting a Microsoft Access Database | Database Solutions for Microsoft Access | databasedev.co.uk
    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •