Designing a Web Page That Accesses a Database

Question:
I am trying to create a site that will take user input via forms, query a database, and return results to the user. I’ve been reading a ton of HTML books and have learned how to create forms, but I want to know how to get them to interact with my Microsoft Access database. Is there an easy way to connect my Web site with Microsoft Access?

Answer:
The ability to access a database via the Web must be supported by the Web server software that you are using. If your Web server software is Internet Information Server (IIS) 3.0 (with Active Server Pages and ActiveX Data Objects installed) or IIS 4.0, you can use Active Server Pages to connect to your database easily.

The following code assumes that you have set up an ODBC data source name (DSN) called MyAccessDatbase in the Windows Control Panel applet. Keep in mind that this is not the only way to get to the data?each method has its pros and cons. This particular code is very short and easy to read and understand, but becomes less efficient the more times it is called in a single instance of an application.

Const adOpenKeyset = 1Const adLockOptimistic = 3  Set rs = Server.CreateObject ("ADODB.Recordset")rs.Open "Select * from students", "DSN=MyAccessDatbase;UID=Admin;PWD", _	adOpenKeyset, adLockOptimistic 

After this code executes, you will have a recordset that you can use to put data on your Web page. You can access the individual fields in a recordset using the following syntax.

rs("MyField1")rs("MyField2")

This code should enable you to retrieve data from a database into your Web page. Happy coding!

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

The Latest

microsoft careers

Top Careers at Microsoft

Microsoft has gained its position as one of the top companies in the world, and Microsoft careers are flourishing. This multinational company is efficiently developing popular software and computers with other consumer electronics. It is a dream come true for so many people to acquire a high paid, high-prestige job

your company's audio

4 Areas of Your Company Where Your Audio Really Matters

Your company probably relies on audio more than you realize. Whether you’re creating a spoken text message to a colleague or giving a speech, you want your audio to shine. Otherwise, you could cause avoidable friction points and potentially hurt your brand reputation. For example, let’s say you create a

chrome os developer mode

How to Turn on Chrome OS Developer Mode

Google’s Chrome OS is a popular operating system that is widely used on Chromebooks and other devices. While it is designed to be simple and user-friendly, there are times when users may want to access additional features and functionality. One way to do this is by turning on Chrome OS