• 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 project designer 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.5 or 2.6 Library (Msado25.tlb or Msado15.tlb) and Microsoft ADO Ext. 2.5 for DDL and Security (Msadox.dll) to support Jet 4.0 DDL. Msado15.tlb isn't a typographic error for the name of the ADO 2.6 type library. Chapter 28 explains how to add these references and the reason for lower type library version numbers for the latest release.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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