Chapter 19. Linking Access Front-Ends to Jet and ClientServer Tables

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