Sharing a Database
When a limited number of people are working on a local area network (LAN), sharing a database is easy. You simply place the database file in a folder that everyone can access, and then limit who can do what to the database by using the same network security you use to protect other information on the network. The number of people who can share a database in this manner depends on how many access it at the same time and what they want to do.
Access manages multiple users fairly well, but you will want to take precautions to prevent multiple users from attempting to update the same record at the same time. For example, if more than one employee at The Garden Company tried to change the same record in the Products table at exactly ...
Get Microsoft® Office Access 2003 Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
