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

Chapter 20. Exploring Access Data Projec... > Working with SQL Server Tables in th...

Working with SQL Server Tables in the Project Designer

ADP use a set of client/server graphical design tools called the da Vinci toolset during their development. Microsoft calls da Vinci MS Design Tools, but the most common name for Access’s implementation of the toolset is the project designer. Access’s project design mode lets you alter the structure of tables, relationships, views, functions, and stored procedures directly from the user interface. SQL Server and other client/server RDBMSs rely on SQL CREATE, ALTER, and DROP statements for design changes. The project designer executes the SQL statements for your design changes each time you confirm saving changes when exiting design mode. The ability to alter the design of the equivalent to linked tables, unavailable in prior versions of Access, is an important feature of projects.

Note

The SQL panes of Access 2003’s product designer don’t include the CREATE VIEW|FUNCTION|PROC[EDURE] AS Name component of the T-SQL statement to create a new object. The project designer adds a CREATE... statement for a new object or an ALTER... statement for an existing object when sending the command to SQL Server.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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