Linking Web Page to Access97

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
malayaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
jonesianConnect With a Mentor Commented:
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
 
PBallCommented:
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
 
malayaAuthor Commented:
Hi Jonesian,

Could you give me some more information.

0
 
jonesianCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.