Access.2007.VBA.Bibl..

Windows security settings just to be able to connect to SQL Server before you even attempt to con-

nect 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 sev-

eral SQL Server-related tasks:

n Convert an Access database to SQL Server for use as a back end (this is known as upsiz-

ing the database)

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

end

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

Getting SQL Server 2005 ..................................................................................................

If you have installed Visual Studio 2005, you should already have SQL Server 2005, as it is installed

by default as part of the Visual Studio installation. To check this, open the Control Panel and select

the Programs and Features applet; note that the Installed On date is the same for Microsoft SQL

Server 2005 and Microsoft Visual Studio 2005 Professional Edition (see Figure 18.1).

FIGURE 18.1

Microsoft SQL Server 2005 listed in Programs and Features.

Part III Adding More Functionality to Office