Access™ 2007 Bible

Chapter 40. SQL Server as an Access Companion

IN THIS CHAPTER

• Learning about SQL Server connections

• Understanding Listener process

• Building Connection strings

• Comparing SQL Server and Access 2007 security

• Accessing SQL Server tables from Access 2007

• Using SQL Server stored procedures and views in Access 2007 applications

• Understanding SQL Server procedures, functions, and triggers

Access projects are used to create and maintain SQL Server 2005 Express edition databases, or "full" SQL Server 2005 databases (from here on usually referred simply as SQL Server). You can also use an Access project to create the user-interface objects and forms, reports, macros, and modules, which get their data from SQL Server. The database window for a project looks very similar to the Access database window you are already accustomed to. In fact, creating the user-interface objects is virtually the same as creating them in Access.

Note

This chapter uses a database named Chapter40.accdb. If you have not already copied it onto your machine from the CD, you'll need to do so now.

Warning

In general, SQL Server Express edition automatically installs as if it is to be executed on the same computer you're working on. In other words, even though SQL Server is a server database, the default for SQL Server Express is to execute on the same computer as a client environment such as Access or Excel.

Note

SQL Server 2005 Express edition is free. You can download it from (http://msdn.microsoft.com/vstudio/express/sql/) and use ...