Connecting to Microsoft Access Databases

ColdFusion lets you access Microsoft Access databases Windows NT, via ODBC and OLE DB drivers.

Configuring Microsoft Access Options (Windows)

If ColdFusion Server is installed on a Windows NT server, you can configure Microsoft access databases as ColdFusion data source using either an ODBC or OLE DB driver. For information about using OLE DB drivers with ColdFusion data sources, see "OLE DB Drivers".

Note OLE DB and ODBC connections to Access function programmatically identically, but OLE DB connections under load prove to be substantially more robust than ODBC. Wherever possible, you should use OLE DB connections to Access data sources instead of ODBC connections.

Note ODBC: Microsoft Access Options (Windows)

The following table describes ColdFusion ODBC options for Microsoft Access data sources. You set these options when you configure a ColdFusion data source. See "Adding Data Sources for ColdFusion" for more information.

Microsoft Access ODBC Options
Option Description
Data Source Name A name for your data source.
Description Descriptive information about the data source.
Database File Click the Browse button to select a database file for a file-based ODBC data source.
System Database Specify a database file to make it accessible to the system or any user, rather than the local user. Note that Access data sources created with ColdFusion and specified as a Database File are automatically created as System ODBC Databases.
Driver Settings Page Timeout -- The length of time in milliseconds before a request for a ColdFusion page times out.
Buffer Size -- The total number of bytes ColdFusion uses to cache application pages. To optimize ColdFusion performance, enter a value.
Default Login A username/password combination ColdFusion uses to access the data source. If your ODBC data source requires a username or password, enter them here. To verify your data source, you need to enter login information here.

Access Connectivity Tips (Windows)

Regardless of whether you use OLE DB or ODBC connections, the following suggestions will improve your Access database connectivity: