O'Reilly logo

Microsoft® Office Access 2003 Step by Step by Online Training Solutions Inc.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required