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.
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.
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.
SQL Server 2005 Express edition is free. You can download it from (
http://msdn.microsoft.com/vstudio/express/sql/) and use ...