Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Linking Web Page to Access97

Posted on 1999-01-10
4
Medium Priority
?
182 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 200 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
This article discusses how to create an extensible mechanism for linked drop downs.
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ā€¦
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

604 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