Access provider types
2010 Office System Driver: Access Database Engine (32-bit)
2007 Office System Driver: Data Connectivity Components
SQL Language: Microsoft Jet Database Engine Programmer's Guide
The Office System Drivers are also installed with Microsoft Office.
SQL Offline requires 32-bit drivers. If you have a 64-bit version of Office installed, you can install the 2007 Office System Driver.
Access Column Type List
Access provider types
Additional qualifiers can be added. For example,
DateTime DEFAULT DATE()
will specify that a field defaults to the time the record was appended. The Access provider type will be passed directly to the CREATE TABLE command and retained in the .OL grid file.
