Sharing Access 2010 Databases

After you create an Access database, you'll want to share it with friends and colleagues. By using Access' built-in sharing features, everyone can view, edit, and delete database information at the same time. And you can create custom front ends that let people use forms and run reports without getting in each other's way. Tim Hill offers clear and to-the-point instruction on how to share your data securely, anticipate pitfalls, and keep everything running smoothly.


• Determine whether Access multiuser sharing is right for you.

• Prepare a database for sharing.

• Share your Access database with a group.

• Handle editing conflicts.

• Fix and prevent data corruption.

• Secure a shared database.

• Maintain a shared database without a database administrator.

• Troubleshoot sharing problems.


Contents

1. Sharing a Database with Multiple Users

2. Splitting a Database and Linking Tables

3. Handling Editing Conflicts

4. Fixing and Preventing Data Corruption

5. Securing a Shared Database


About the Author

Tim Hill is a data scientist living in Boulder, Colorado. He holds degrees in mathematics and statistics from Stanford University and the University of Colorado. When he's not crunching numbers, Tim climbs rocks, hikes canyons, and avoids malls.