FP databases + iis6 = not saving to db

[Dan Bright]

We are in the process of moving our sites from IIS4 to WS2003 and IIS6.
Several of the sites use a FrontPage form that links to an Access
database on the web server. They were created using the FP tools and
databse connection provided through the FP extensions. Since the move
to IIS6.0, the forms have not been able to write to the database. When
you submit the form, you receive a confirmation page and it appers to
the user that it worked. Hower, the record is not written to the database.

This is an application that has been in place for several years. I open
the site in FP and checked the database connection in FP and everything
looks ok but obviously isn't.

Could it be permissions? We have run into issues with the default
permission issues in IIS6.0, but I have also tried granting "full
control" to "everyone" with the same results.

I have also tried commenting out the "on error resume next" line of the
asp pages that connect to the database, but this also produces no results.

Thanks for the help.
Dan Bright

 

[Terry Ziemer]

I am having a similar problem, although it is
intermittent. Most of the time the data gets into the
database, every once in a while, it does not. I do not
understand what is causing this.