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 ...
Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
