Using Access as a front end to SQL Server is a topic worthy of a complete book on its own, but the
Upsizing Wizard will at least help with the first steps toward creating a client-server application:
moving your data from Access tables to SQL Server tables.Summary ..........................................................................................................................
Because of new security features in Office and Windows, it is much more difficult to connect an
Access database to a back-end SQL Server database. With the information in this chapter, you
should be able to negotiate the security settings that allow you to connect an Access database to a
back-end SQL Server database, allowing you to use an Access database (or project) front end to
data stored in SQL Server tables.Part III Adding More Functionality to Office