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

Chapter 21. Moving from Jet Queries to T... > Creating Tables with ANSI-92 DDL

Creating Tables with ANSI-92 DDL

You can create new tables in your current database with DDL reserved words, which are identical for Jet 4.0 and SQL Server 7.0+. Using SQL to create new tables is of primary interest to developers, not users, of Access applications because it’s much easier to create new tables with the Jet or SQL Server graphical table design tools than writing the equivalent DDL statements. In some cases, such as emulating Jet crosstab queries with T-SQL stored procedures, however, you must create tables with SQL statements.

Note

Jet supports ANSI-92 DDL statements only in VBA code and requires use of the OLE DB provider for Jet 4.0 to establish an ADODB.Connection object to the Jet database. You must add references in the VBA editor to the Microsoft ActiveX Data Objects 2.7 Library (Msado15.dll) and Microsoft ADO Ext. 2.7 for DDL and Security (Msadox.dll) to support Jet 4.0 DDL. Chapter 28 explains how to add these references in the VBA editor.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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