Linking an Access front end to data in a SQL Server database

Windows security settings just to be able to connect to SQL Server before you even attempt to connect Access to SQL Server or upsize an Access database.

This chapter helps you navigate through the SQL Server and Windows settings you need to do several SQL Server-related tasks:

■ Convert an Access database to SQL Server for use as a back end (this is known as upsiz-ing the database)

■ Create a client/server application with a SQL Server back end and an Access project front end

■ Link an Access database to tables in a SQL Server database

0 0

Post a comment