Calling / writing to Access 97 database using .htm/.hta/vbscript

[MedievalMan]

I'm making a electronic form available to a multitude of computers on a network (many who only have Windows XP and our companies software on them.)

This form (.hta / .vbscript seems pretty easy to learn) needs to grab information and write to a database. We have a license for Access 97 only at the moment.

This data would then be stored in a database (with the test# as the key), so it can be brought up again on any other computer connected to the network and added to by either the technician or supervisor.

As well, this will make the data organized for reporting/billing purposes.


My question is: can I do this with just internet explorer / .hta files as the user interface (thus not having to have Access installed on the user computers) and an Access database stored on the network drive?

Thanks.

 

[fneily]

Too bad you don't have Access 2000 and above. You can create Data Access Pages (DAPS) that are actually web pages. If you search Microsoft: Access Other topics forum on DAP or "data access page" you'll find alot of info on them. They're interactive web pages.
For Access 97, maybe this'll help:
Creating Intranet and Internet Solutions with MS Access 97

http://www.microsoft.com/technet/archive/office/office97/maintain/off304ef.mspx?mfr=true