O'Reilly logo

Beginning Access™ 2007 VBA by Denise Gosnell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 10. Building SQL Server Applications with Access Project

So far, all the examples in this book have dealt with standard Access database files (ACCDB files). An Access Project (ADP file) is another type of Access database file that is designed specifically for working with SQL Server databases. In this chapter, you will explore how to create and manage SQL Server databases using Access Projects. You'll learn how to create new Access Projects from scratch and explore the various SQL Server objects that you can create and manage from an Access Project, such as tables, stored procedures, views, and functions. You will also migrate an existing Access database to SQL Server and provide guidelines for resolving any problems that occur during the migration.

This chapter focuses on using Access Projects to work with features that are specific to SQL Server, but it does not cover forms and modules. You still write forms and modules in Access Projects as you have done in prior chapters.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required