Connect to Microsoft Access database

If you run ColdFusion on a Windows NT platform, you can configure a Microsoft Access database as a data source using ODBC and OLE DB drivers.

 

Notes

 

To complete the connection:

  1. Select options as described in the following table. For the steps involved in configuring your data source, see Configure ODBC data sources.

 

Field

Description

Default

Data Source Name

This field displays the name that you entered on the main Data Sources page. You can edit it here.

Filled

Description

Enter a brief description about the data source.

Blank

Database File

Click Browse Server to locate and enter the path and filename of a database file.

Blank

System Database

If you want to secure access to the specified database file, click Browse Server to locate and enter a database that contains database security information.

 

The system database is usually located in winnt/system32/system.mdw.

Blank

Driver Settings/
Page Timeout

Enter the time (in tenths of a second) before a request for a ColdFusion page times out.

600

Driver Settings/
Buffer Size

Enter the total number of bytes that ColdFusion should use to cache application pages. Enter a value to optimize ColdFusion performance.

0

Default Login/ Username

If your ODBC data source requires a username and password to restrict access, enter the username. Remember that to verify any data source protected with a username and password, you have to enter the login information.

admin

Default Login/ Password

If you have entered a username to restrict access, enter a password.

None

 

  1. Click Create to save the configuration.

 

For tips about working with a Microsoft Access database, refer to the book Advanced ColdFusion Server Administration.

Related topics