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

Chapter 11. Advanced Query Techniques > Jet 4.0 ANSI-92 Extensions

Jet 4.0 ANSI-92 Extensions

Jet 4.0, the version of Jet that ships with Access 2000 and later, includes expanded support for the ANSI-92 standard. Although these extensions are not available via the Access user interface, you can tap into them using ADO code. This section covers the extensions and the functionality they afford you. Because I have not yet covered ADO, you might want to refer to Chapter 14 to better understand the examples. For now, you need to understand that the code examples in this section use the ADO Command object to execute SQL statements that create and manipulate database objects.

Table Extensions

Six table extensions are included with Jet 4.0. These extensions provide you with the ability to


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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