How to Turn the Access Database Into a Web Page on Dreamweaver ColdFusion

Written by erica harisson
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Turn the Access Database Into a Web Page on Dreamweaver ColdFusion
Using Adobe ColdFusion and Microsoft Access, you can gather and display information on a website. (website image by 6922 Designer from Fotolia.com)

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:
Moderate

Other People Are Reading

Instructions

    Connect to the Access Database

  1. 1

    Open ColdFusion Administrator by using the ColdFusion Administrator link on the server the application is installed on.

  2. 2

    Log in using your administrator password.

  3. 3

    Click "Data and Services," followed by "Data Sources."

  4. 4

    Create a connection to your Microsoft Access database using your server information and the information in the Resources section of this article.

    Interact with Access

  1. 1

    Open your desired Web programming application.

  2. 2

    Code your website pages with fields for gathering or displaying information from the database.

  3. 3

    Use <cfquery> tags to get information from the Access database.

  4. 4

    Display information gathered using <cfoutput> tags to display your query results.

  5. 5

    Update data or add new data to the database using either <cfupdate>, <cfinsert> or <cfquery> tags in your Web pages.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.