Special Edition Using Microsoft® Office Access 2003

Chapter 19. Linking Access Front-Ends to Jet and Client/Server Tables

In this chapter

• Creating Multiuser Access Applications by Linking Tables

• Evaluating the Benefits of Migrating to Client/Server Databases

• Choosing a Client/Server Migration Strategy

• Upsizing a Single-File Application to SQL Server 2000

• Moving the Upsized Database to Another Server

• Linking Client/Server Tables Manually

• Adding User Logins with the OSQL Utility

• Password-Protecting Access Front-Ends

• Applying User-Level Security to Access Front-Ends

• Changing Database Group and User Permissions

• Troubleshooting

• In the Real World—The (Almost) Free Lunch

Creating Multiuser Access Applications by Linking Tables

A single .mdb file that contains Access application objects (forms, reports, macros, and ...