Solved

Linking Web Page to Access97

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Showing your events from Google Calendar in Google Maps Why? I travel all week and I thought it would be ideal if staff in office knew where I was based on my calendar. (OK real reason: my son wanted to see where I would be working, and I thoug…
SASS allows you to treat your CSS code in a more OOP way. Let's have a look on how you can structure your code in order for it to be easily maintained and reused.
In this Micro Tutorial viewers will learn how to create navigation buttons that change on rollover, using CSS (Continuation of the CSS Image Sprite tutorial) Create a parent ID for all the list items       - Specify position: absolute and display: block…
The viewer will receive an overview of the basics of CSS showing inline styles. In the head tags set up your style tags: (CODE) Reference the nav tag and set your properties.: (CODE) Set the reference for the UL element and styles for it to ensu…

776 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