Thread: multiple users of one database
04-10-11, 11:30 #1Registered User
- Join Date
- Apr 2011
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
04-10-11, 15:16 #2Moderator
Provided Answers: 15
- Join Date
- Mar 2009
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.ukHave a nice day!