I currently use Access97 so perhaps I need to upgrade to Access 2002 to do this. Can anyone give me some feedback on whether this is doable:
I would like to put a database on the internet, then put up a web page that has a form on it that allows users to input data and then save it to the database. I can create a web form form HTML and send the submit action to an active server page that writes to the database. However, I believe that there is some kind of Access Web Form that can also do this and shortcut the work involved. Comments from anyone? If there is an Access solution, which version of Access do I need to use. And secondly, what is involved. Do I need to FTP the access web form up to an ISP that supports ASP or will any ISP do ok?
The Access Web From you refer to is Data Access Pages. It's a great idea however I haven't been able to get it to work on a shared hosting web server. You'll have to talk with your hosting ISP.
The rest of your request is a standard thing to do with Access on the web. Since Access 97 is rather dated, I recommend upgrading. FrontPage has a database wizard that would facilitate your effort.
--
Tim Burkart
Trinity Internetworking LLC
www.trinityinternetworking.com
BTW you can only do this on an IIS web server.
You need at least A2K to create DAP's, which I believe is what you refer to by an 'Access Web Form'. I believe your users MUST have IE 4.0 or above to use these forms (could even be 5.0, not certain). To my knowledge, they don't work with Netscape, you may want to look into it.
I personally prefer the approach you are already using, unless you can be 100% certain what your client browsers will be...
hth
brett
Ooops. I was saying ISP when I meant to say ASP (as in Application Server Provider). I assume you were making the same mistake. If not, if you are doing this all on your own web server, then, no, your ISP has nothing to do with the functionality of a DAP or ASP (active server pages).