O'Reilly logo

Alison Balter's Mastering Access 2002 Enterprise Development by Alison Balter

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

Maintaining a SQL Server Database from an Access Project

One of the major benefits of Access Projects is that they allow you to easily administer the SQL Server database right from within Microsoft Access. This includes the capability to create, modify, rename, and delete SQL Server tables, views, stored procedures, user-defined functions, and database diagrams. This section shows you how to perform these various tasks. It is important to remember that any changes from within Access are immediately reflected within the associated SQL Server database.

Working with SQL Server Tables

As mentioned, you can create, modify, rename, and delete SQL Server tables directly from the Access environment. The designers available to you from within an ADP are ...

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