[WEB4LIB] Web Form and Access Database

[Peter Verhagen]

Its difficult, but not impossible. It really depends on how
complicated your form needs to be, how you plan on tabulating the
data, etc.

As we speek I am currently developing a web links database application
all accomplished using ASP (HTML) on Windows 2000 and a Open Source
database called Firebird. Firebird was developed using Borland's
Interbase 6 source code that Borland had released into the Open Source
Community in the summer of 2000 (please see
http://firebird.sourceforge.net for more). And just so everyone knows
I know some SQL but never programmed an ASP application before, and
thus far its been alot of fun.

Your best bet - do a google search looking for "Microsoft", "Access"
and "ODBC". You might want to add "ASP" if your form is going to exist
on a Windows NT/2000 server.

If anyone is interested when this project becomes completed, would
like to read about it's progress or even if they'd like to help out
contact me off list.

Peter Verhagen
Systems Administrator
St. Albert Public Library
pverhagen at sapl.ab.ca

> Is it possible to create a web form that sends data to a
> Microsoft Access Database?
>
> Our library is currently working on a database to store patron
> reference requests.  We would also like to create an Ask a
> Librarian web form and would like the two to work together.  Has
> anyone else tried a similar project? Can anyone recommend any
> books or other resources I can use to learn more about this?
>
> Thanks in advance for any help you can provide.
>
>
> Ruth Harrison
> Texas State Law Library
> P O Box 12367
> Austin TX 78711-2367
> 512.463.1724
> 512.463.1728 Fax
> 512.463.1722 Circ/Ref
> http://www.sll.state.tx.us
> ruth.harrison at sll.state.tx.us