Solved

Linking Web Page to Access97

Posted on 1999-01-10
4
174 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Foreword (July, 2015) Since I first wrote this article, years ago, a great many more people have begun using the internet.  They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
Use these top 10 tips to master the art of email signature design. Create an email signature design that will easily wow recipients, promote your brand and highlight your professionalism.
In this tutorial viewers will learn how to define a gradient in CSS. Create a new HTML document with an internal stylesheet.: Create a div in CSS and name it Gradient. Define the background as "linear-gradient(to right, #ee3668, black)". Ensure you …
The viewer will learn the benefit of using external CSS files and the relationship between class and ID selectors. Create your external css file by saving it as style.css then set up your style tags: (CODE) Reference the nav tag and set your prop…

707 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

16 Experts available now in Live!

Get 1:1 Help Now