Updating an MSAccess97 DB from a FP98 web Using MS Personal Web Server

[vsburgess]

I've had great success in allowing users on our companies intranet query my small MSAccess97 database, and get back useful information.<br>
<br>
However, I also want to give users the ability to alter existing records in this database. Preferably by entering a query, having the data return to a form, then allowing them to change the data on the form and return the changed record to the MSAccess97 database.<br>
<br>
What I'm looking for is a resource, book or web site, that can walk me through setting up such a thing, without using the MSAccess97 wizards, as they don't seem to be doing the job, or something to tell me how to fix what the wizard creates so that it actually works.

 

[grasupt]

create the page with the fields on it. Create an asp page (as a form handler) that has the update fields ...where.... SQL clause. link it via an ODBC and use the POST method on the submit button.<br>
<br>
Still need some error handlers and other stuff but that will get ya there...<br>
<br>
also , try lookin at msdn.microsoft.com/workshop/languages/fp/dev/mfp98c4.asp<br>
<br>
or <br>
<br>

http://www.asp101.com<br>

<br>
for a better explaination

 

[vsburgess]

Thanks ... I'll do that.