Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Microsoft: Access Other topics FAQ

Access Web Resources

Access Database on the Web by Bullschmidt
Posted: 23 May 03 (Edited 23 Jun 03)

You and others can have access to a database hosted on the Web from any location that has a browser with an Internet connection.

The Web database concept makes sense if you and your people want to do work in various locations in or outside the office and still be "plugged" in.

For example you could have employees enter timesheets or have sales reps log their contacts.  Or perhaps you'd like customers to be able to check the status of their orders online without having to call the company.

If you want a Web database, typically what would happen is that a database such as Access or MySQL (basically just consisting of tables) would be put on the Web.

Then "dynamic" Web pages (actually ASP pages which include VBScript, HTML, and/or JavaScript) would be created acting like the old desktop database's queries, forms, and reports to access the database - all hosted on a Web Server.

Dynamic Web pages are similar in many ways to regular HTML pages.  But they are "live" because the user can read from and write to information in the database.  An example where you can login and add, edit, or view fictional customers and invoices is at http://www.bullschmidt.com/login.asp

Not all Web hosts will handle dynamic Web pages but many do.  The Web hosts that can handle ASP pages usually have a Windows 2000 operating system running an IIS Web server.

Here are a few good ASP sites:
o ASP101 Samples - http://www.asp101.com/samples
o W3Schools ASP Tutorial - http://www.w3schools.com/asp
o Microsoft VBScript Language Reference - http://msdn.microsoft.com/scripting/default.htm?/scripting/VBScript/doc/vbscripttoc.htm

And the following newsgroup is good:

Or for a "quick and dirty" generic ASP solution to putting database tables on the Web that just requires setting up a configuration page for each table or query and uploading the database to the Web as long as you have an autonumber field in each table (and as a more advanced issue you'll probably sometime in the future want to create login capabilities), perhaps try something like this:
GenericDB by Eli Robillard

J. Paul Schmidt, Freelance Access and ASP Developer
http://www.Bullschmidt.com/Login.asp - Database on the Web Demo
http://www.Bullschmidt.com/Access - Sample Access Invoices Database

Back to Microsoft: Access Other topics FAQ Index
Back to Microsoft: Access Other topics Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close