• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Developing an ADP Applicatio... > Maintaining a SQL Server Database fr...

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 the same as those available in SQL Server Enterprise Manager.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint