Solved

Linking Web Page to Access97

Posted on 1999-01-10
4
175 Views
Last Modified: 2010-04-09
Hi,
I am a final year student desperately in need of help in my project.

1) I am building a web page which will access parts of my database(nuilt
in MS Access97)

2) I also want to password protect my web page.

Thanking You

Randeep
0
Comment
Question by:malaya
  • 2
4 Comments
 
LVL 6

Expert Comment

by:PBall
ID: 1841513
Options:
1. client side using DHTML data binding
see Microsoft Workshop on HTML, DHTML and CSS section.

This method can be more challenging than the server side solution.  It will require extensive knowledge of Javascript / VBScript, browser DOM, and data binding components such as ADC.

Somewhat limited (maybe because I haven't get a way to
get around some of the problems such as populating a listbox with live data).

2. server side using CGI (recommend ASP)
see Microsoft Workshop on Server Side Technology (particularly Active Server Pages).

ASP can pack quite a punch.  It can do what you described above and more.

How?
If you haven't, go get NT4.0 Options Pack that corresponds to your Operating System (Personal for W95/98 /Peer Web Server for NT 4.0 Client /IIS4.0 for fullblown NT4.0 Server).  You can get this from Microsoft site free (beware...it's huge).

Set up DSN for your Access database (Control Panel, ODBC32)

Go read some good book on ASP like Professional ASP 2.0 by WROX

0
 

Accepted Solution

by:
jonesian earned 100 total points
ID: 1841514
We used Visual Interdev, IIS 4.0 and SQL Server 6.5 to develop and serve pages from an Access database.  It also has password protection.  Works well, but hasn't been tested thoroughly under a live environment yet.

ASP was the only option available to us (due to client requirements), but has proved much better than our previous database work using Delphi CGI programs, which was fairly slow and not as versatile.

Good luck with the project.

Ian
0
 

Author Comment

by:malaya
ID: 1841515
Hi Jonesian,

Could you give me some more information.

0
 

Expert Comment

by:jonesian
ID: 1841516
Ok :

We used Visual Interdev to develop the ASP.  With this, you can develop the code and database alongside each other.  Using VBScript, you can issue SQL commands to get information from the Access database.  In order for this to happen, we used SQL Server 6.5 to handle the SQL requests and return the data.  IIS4.0 just handles the ASP code (in this case, VBScript), executes the commands, and sends the resulting HTML to the browser.

Unfortunately, due to cutomer confidentiality, I can't tell you where the site is until they publicly announce it.

Ian.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article discusses how to create an extensible mechanism for linked drop downs.
Find out what you should include to make the best professional email signature for your organization.
In this tutorial viewers will learn how to embed an audio file in a webpage using HTML5. Ensure your DOCTYPE declaration is set to HTML5: : The declaration should display (CODE) HTML5 is supported by the most recent versions of all major browsers…
In this tutorial viewers will learn how to embed videos in a webpage using HTML5. Ensure your DOCTYPE declaration is set to HTML5: "<!DOCTYPE html>": Use the <video> tag to insert a video. Define the src as the URL of your video; this is similar to …

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now