Form results to Access 2003 database

[Guest]

We recently upgraded to FP2003 from FP2000. I'm currently working on a form
where I want the results to go to the access db. I just used the option to
have fp create the db. The form is working fine but the results are not
getting updated on the db.

We have not done anything to our server which does have the extensions on it
from FP2000. I have created many forms in the past using FP2000 and using the
option of sending the results to the db and it has worked fine. Can you let
me know what I need to do to get the results to be updated on the db using
fp2003.

Thanks

 

[Jim]

This is a grasp, from something I confirmed last week, but are you saving
the form page as .ASP vice .HTM?

 

[Guest]

It prompts me to save it as a .asp file, so yes, the file is currently a
..asp. file.

 

[Guest]

Do you get any error messages when you try to write to the access db? I am
having some problems writing to access after switching to frontpage 2003 (see
my post on this newsgroup). It could be a permissions issue.

 

[Guest]

I don't receive an an error message when after submitting the form, but I do
receive the following error message when I review the code:

<%
' FP_ASP ASP Automatically generated by a Frontpage Component. Do not Edit.
On Error Resume Next

strErrorUrl = ""

If Request.ServerVariables("REQUEST_METHOD") = "POST" Then
If Request.Form("VTI-GROUP") = "0" Then
Err.Clear

Set fp_conn = Server.CreateObject("ADODB.Connection")
FP_DumpError strErrorUrl, "Cannot create connection"

Set fp_rs = Server.CreateObject("ADODB.Recordset")
FP_DumpError strErrorUrl, "Cannot create record set"

fp_conn.Open Application("miles_log_ConnectionString")
FP_DumpError strErrorUrl, "Cannot open database"

fp_rs.Open "Results", fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic,
adCmdTable
FP_DumpError strErrorUrl, "Cannot open record set"

fp_rs.AddNew
FP_DumpError strErrorUrl, "Cannot add new record set to the database"
Dim arFormFields0(3)
Dim arFormDBFields0(3)
Dim arFormValues0(3)

arFormFields0(0) = "Weekly_miles"
arFormDBFields0(0) = "Weekly_miles"
arFormValues0(0) = Request("Weekly_miles")
arFormFields0(1) = "Last_name"
arFormDBFields0(1) = "Last_name"
arFormValues0(1) = Request("Last_name")
arFormFields0(2) = "Team_name"
arFormDBFields0(2) = "Team_name"
arFormValues0(2) = Request("Team_name")

FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0

If Request.ServerVariables("HTTP_USER_AGENT") <> "" Then
FP_SaveFieldToDB fp_rs, Request.ServerVariables("HTTP_USER_AGENT"),
"Browser_type"
End If
If Request.ServerVariables("REMOTE_HOST") <> "" Then
FP_SaveFieldToDB fp_rs, Request.ServerVariables("REMOTE_HOST"),
"Remote_computer_name"
End If
FP_SaveFieldToDB fp_rs, Now, "Timestamp"
If Request.ServerVariables("REMOTE_USER") <> "" Then
FP_SaveFieldToDB fp_rs, Request.ServerVariables("REMOTE_USER"), "User_name"
End If

fp_rs.Update
FP_DumpError strErrorUrl, "Cannot update the database"

fp_rs.Close
fp_conn.Close

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

End If
End If

%>

 

[Guest]

i'm having the exact same problem. please let me know if you get it solved.