Adobe ColdFusion is a Web programming application language that allows users to develop complex, interactive websites with a limited knowledge of Web languages. ColdFusion is able to interact with many databases, including Microsoft Access. Connecting to Microsoft Access requires using a JDBC driver, which is provided by Adobe, and configuring the connection to your database. Once the ColdFusion server has access to the database, you can design pages that will read and write to your database.
- Skill level:
Other People Are Reading
Open ColdFusion Administrator by using the ColdFusion Administrator link on the server the application is installed on.
Log in using your administrator password.
Click "Data and Services," followed by "Data Sources."
Create a connection to your Microsoft Access database using your server information and the information in the Resources section of this article.
Connect to the Access Database
Open your desired Web programming application.
Code your website pages with fields for gathering or displaying information from the database.
Use <cfquery> tags to get information from the Access database.
Display information gathered using <cfoutput> tags to display your query results.
Update data or add new data to the database using either <cfupdate>, <cfinsert> or <cfquery> tags in your Web pages.
Interact with Access
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for