FP 2002 Form and Access Databases

[Melissa23]

I created a form a few months ago and had the information sent to an access database. It worked fine for the first month and then now it won't work at all. I have checked my connections and everything seems to be correct. I am at a total loss as to what's gone wrong. Any help would be greatly appreciated!

 

[ElEye]

What happens now? Do you get an error? If so, what is it?

Dave B
Flashspot.com

 

[Melissa23]

I actually get no error message at all. That's what makes this so hard to figure out! I had everything set up and it worked fine for a month. I then created a report from the information in the database and it hasn't worked since. I have checked the connections and they look fine. I am totally lost as to why this is no longer working.

 

[ElEye]

Without an error message this is a toughie.

Just to be sure, do you have "Friendly Errors" enabled? If so, turning them off may give you an error message with which this can be troubleshot.

To check it, while in Internet Explorer:
TOOLS -> INTERNET OPTIONS -> ADVANCED -> SHOW FRIENDLY HTTP ERROR MESSAGES

If you already did this or if there is still no error, next step is to check the .log files. Do you have access to the IIS (or other service) files on the server? Dave
[

http://flashspot.com

]

 

[Melissa23]

Ok, I did have the "Friendly errors" enabled. I disabled them and still I have no error message. I do not have access to files on the server. If I know what I need to find though I know who to contact for that.

 

[Guest_imported]

If you have your database hosted off site, check and make sure that the ASP did not run MS new security tool. It resets the premissions on all the files. Took me forever to figure out the problem.

 

[ElEye]

Does anything happen? Or does it appear to work correctly, but nothing happens?

If you have a link perhaps we can try it out. Dave
[

http://flashspot.com

]

 

[Melissa23]

It appears to work correctly. I enter false information and hit submit. It goes to the Form Confirmation page. Then it allows me to return to the form. I then go and check the database and the information I entered is not there. I unfortunetly can not provide a link. I have gone through and checked the link to the database and everything appears to be normal. I did just notice however that when I clicked on update database connection in the form properties it mentioned the Database Results Wizard. I have not done anything with this. Could this cause a problem?

 

[Melissa23]

How do I check the security tool?

 

[ElEye]

Well, I'm kinda stabbing in the dark here.

If you are absolutely certain that your database connection is correct then I can only guess that since you're not getting an update nor an error message that your form is not posting to the database.

I trust there's a SAVE or SUBMIT button on the bottom of the form. If you are using clean .ASP, does its HTML look something like this?:
<input type=&quot;submit&quot; name=&quot;Action&quot; value=&quot;SAVE&quot;>

If you're using a FP Database Results or Forms Wizard you'll only see the submit part. The connection and functions are handled in the GLOBAL.ASA file. This is best not edited manually. Rather you can try verifying your database:
TOOLS -> WEB SETTINGS -> DATABASE -> (select the database) -> VERIFY -> APPLY.

Seperately, as mentioned above by &quot;jfrey&quot; updates can bork security settings. But my experience with this is that you get an error that you can't write to the database. This would be because write-permissions changed. But you said you get no error. So that doesn't sound like your difficulty. Dave
[

http://flashspot.com

]

 

[Melissa23]

Well, now when I go into the html of my page this is what I have:

<%
' FP_ASP ASP Automatically generated by a Frontpage Component. Do not Edit.

On Error Resume Next
Session(&quot;FP_OldCodePage&quot = Session.CodePage
Session(&quot;FP_OldLCID&quot = Session.LCID
Session.CodePage = 1252
Err.Clear

strErrorUrl = &quot;&quot;

If Request.ServerVariables(&quot;REQUEST_METHOD&quot = &quot;POST&quot; Then
If Request.Form(&quot;VTI-GROUP&quot = &quot;0&quot; Then
Err.Clear

Set fp_conn = Server.CreateObject(&quot;ADODB.Connection&quot
FP_DumpError strErrorUrl, &quot;Cannot create connection&quot;

Set fp_rs = Server.CreateObject(&quot;ADODB.Recordset&quot
FP_DumpError strErrorUrl, &quot;Cannot create record set&quot;

fp_conn.Open Application(&quot;form_ConnectionString&quot
FP_DumpError strErrorUrl, &quot;Cannot open database&quot;

fp_rs.Open &quot;form1&quot;, fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic, adCmdTable
FP_DumpError strErrorUrl, &quot;Cannot open record set&quot;

fp_rs.AddNew
FP_DumpError strErrorUrl, &quot;Cannot add new record set to the database&quot;
Dim arFormFields0(7)
Dim arFormDBFields0(7)
Dim arFormValues0(7)

arFormFields0(0) = &quot;New_User&quot;
arFormDBFields0(0) = &quot;New_user&quot;
arFormValues0(0) = Request(&quot;New_User&quot
arFormFields0(1) = &quot;Current_User&quot;
arFormDBFields0(1) = &quot;Current_user&quot;
arFormValues0(1) = Request(&quot;Current_User&quot
arFormFields0(2) = &quot;New_Cost_Center&quot;
arFormDBFields0(2) = &quot;New_Cost_Center&quot;
arFormValues0(2) = Request(&quot;New_Cost_Center&quot
arFormFields0(3) = &quot;Technician&quot;
arFormDBFields0(3) = &quot;Technician&quot;
arFormValues0(3) = Request(&quot;Technician&quot
arFormFields0(4) = &quot;Asset&quot;
arFormDBFields0(4) = &quot;Asset&quot;
arFormValues0(4) = Request(&quot;Asset&quot
arFormFields0(5) = &quot;Current_Cost_Center&quot;
arFormDBFields0(5) = &quot;Current_Cost_Center&quot;
arFormValues0(5) = Request(&quot;Current_Cost_Center&quot
arFormFields0(6) = &quot;Date&quot;
arFormDBFields0(6) = &quot;Date&quot;
arFormValues0(6) = Request(&quot;Date&quot

FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0

If Request.ServerVariables(&quot;HTTP_USER_AGENT&quot <> &quot;&quot; Then
FP_SaveFieldToDB fp_rs, Request.ServerVariables(&quot;HTTP_USER_AGENT&quot, &quot;Field1&quot;
End If
If Request.ServerVariables(&quot;REMOTE_HOST&quot <> &quot;&quot; Then
FP_SaveFieldToDB fp_rs, Request.ServerVariables(&quot;REMOTE_HOST&quot, &quot;Field2&quot;
End If
If Request.ServerVariables(&quot;REMOTE_USER&quot <> &quot;&quot; Then
FP_SaveFieldToDB fp_rs, Request.ServerVariables(&quot;REMOTE_USER&quot, &quot;Field4&quot;
End If

fp_rs.Update
FP_DumpError strErrorUrl, &quot;Cannot update the database&quot;

fp_rs.Close
fp_conn.Close

FP_FormConfirmation &quot;text/html; charset=windows-1252&quot;,_
&quot;Form Confirmation&quot;,_
&quot;Thank you for submitting the following information:&quot;,_
&quot;chform.asp&quot;,_
&quot;Return to the form.&quot;

End If
End If

Session.CodePage = Session(&quot;FP_OldCodePage&quot
Session.LCID = Session(&quot;FP_OldLCID&quot

 

[Melissa23]

I went through and verified the connection through web settings and the connection is fine.

 

[ElEye]

Next stab in the dark:

If your Web is Disk-based: make a backup copy of the database on the server, as well as anything else that may be different than your Web. Then republish using the overwrite everything publish option.

If your Web is Server-based, or if the above doesn't help, try making a new form. Don't copy/paste, try reentering fresh. Dave
[

http://flashspot.com

]

 

[Melissa23]

I am probably just going to start over. This is server based. I was trying to avoid creating a new form and database, but nothing else seems to be working. Thanks for your help!