Web forms not saving

B

Brian

I have two web forms running on a company intranet that are supposed to be writing to two separate Access databases. I have users viewing the results by using Crystal Reports web. The problem is both webforms seem to just stop saving for no apparent reason. The confirmation page displays the information as being saved, but when I open the access database the information has not been populated. The server is Windows 2000 with SP4 and a Domain Controller, IIS 5.0. I am using Frontpage 2002.

I have tried restarting IIS and that doesn't seem to help. Restarting the server will temporarily fix it, but I never know at what point it blows up and my users never receive any error messages

Thanks in advance
 
J

Jim Buyens

Please read the article:

Diagnosing Errors Saving a Form to a Database
http://www.interlacken.com/winnt/tips/tipshow.aspx?tip=35

which will at least get you some error messages to
investigate.

If I had to guess, though, I'd bet that Crystal Web is
seizing control of the .mdb file. If so, you may be able
to resolve the problem by changing the "Open" options in
Crystal, or by switching to SQL Server.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------


-----Original Message-----
I have two web forms running on a company intranet that
Click to expand...
are supposed to be writing to two separate Access
databases. I have users viewing the results by using
Crystal Reports web. The problem is both webforms seem to
just stop saving for no apparent reason. The confirmation
page displays the information as being saved, but when I
open the access database the information has not been
populated. The server is Windows 2000 with SP4 and a
Domain Controller, IIS 5.0. I am using Frontpage 2002.
I have tried restarting IIS and that doesn't seem to
Click to expand...
help. Restarting the server will temporarily fix it, but I
never know at what point it blows up and my users never
receive any error messages.
 
Top