the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
Depends if you're trying to make the database interract via web pages of not.
If you want genuine interration (posting data, running complex queries etc) HTML isn't up to it. You'll need a genuine scripting language like .asp, .php or coldfusion (or even .net - but I won't mention that).
Er... yes you need to install asp if you're working on a PC at home or in a network. This is where it gets tricky. If you've got Win98 .asp comes with PWS (personal Web Server) which is not installed by default (you'll need an installation disk). If you've got XP Home edition, you're out of luck, you can't install it. If you've got XP Professional you can install IIS5 ( or IIS6) which should install .net service which will run .asp pages.
If you need to go down the .php route it's even more complicated. You'll need server software - for WIn98 and XP Pro it's as above (but then you probably wouldn't want to run .php amyway). Apache Server is the best to get, and last time I looked it was free as was (is?) .php.
Use google to search the internet for Apache and php download sites. The rest is a case of follwing the manual for these I'm afraid.
I've used ColdFusion directly to an Access MDB. Looked at converting the mdb to MySQL and decided that the ColdFusion approach was one less step to deal with. Implemented in a fairly short time frame. Been stable now for about 9 months.