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

vsburgess · Apr 26, 1999

I've had great success in allowing users on our companies intranet query my small MSAccess97 database, and get back useful information. 
 
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. 
 
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 · Jun 14, 1999

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. 
 
Still need some error handlers and other stuff but that will get ya there... 
 
also , try lookin at msdn.microsoft.com/workshop/languages/fp/dev/mfp98c4.asp 
 
or

http://www.asp101.com

for a better explaination

vsburgess · Jun 15, 1999

Thanks ... I'll do that.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

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

vsburgess

MIS

grasupt

MIS

vsburgess

MIS

Similar threads

Part and Inventory Search

Sponsor