Error with INSERT INTO statement for Access 2003

[Invisible Bunny King]

Hi. I have been trying to get a registration form for my website to work. On my testing server, it worked great. Once I ul it to my server, it does not work. I have check out other forums to get help, but nothing seems to work. At first, people thought it was a permissions problem, but that is not the case.
What happens is that when I submit the form to be inserted into my Access table, I receive an error saying it can not process the Execute on line 41, the line that would make the records go to my database.
Following is the code I have for the form. Please bear with me for the number of fields that I have in this form.
If anyone can offer suggestions, it would be much appreciated.
You can see this page in action at http://www.centreicehockey.com/register222.asp

<!--#include file="Connections/hockeycards.asp" -->
<!--#include file="adovbs.inc"-->
<%
Dim objConn
Dim dbPath
Dim strSQL
Dim tableName
Dim rscustomers
Dim mytransfer
dbPath="/db/Hockeycards.mdb"
sConnection="Provider=Microsoft.Jet.OLEDB.4.0; " & _
            "Data Source=" & Server.MapPath(dbPath) & ";"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.mode =3 '3="adModeReadWrite
LockType="adLockOptimistic"
Set rscustomers = Server.CreateObject("ADODB.Recordset")
tableName="CustomerList"
strSQL="SELECT * FROM CustomerList"
rscustomers.Open strSQL, sConnection
CursorType="adOpenKeyset"
CursorLocation="adUseServer"
 
FirstName = Request.Form("FirstName")
LastName =Request.Form("LastName")
Uname=Request.Form("Uname")
Pass=Request.Form("Pass")
Email=Request.Form("Email")
PhoneNumber=Request.Form("PhoneNumber")
FavoriteNHLPlayer=Request.Form("FavoriteNHLPlayer")
BillingAddress=Request.Form("BillingAddress")
BillingCity=Request.Form("BillingCity")
BillingProvince=Request.Form("BillingProvince")
BillingPostalCode=Request.Form("BillingPostalCode")
ShippingAddress=Request.Form("ShippingAddress")
ShippingCity=Request.Form("ShippingCity")
ShippingProvince=Request.Form("ShippingProvince")
ShippingPostalCode=Request.Form("ShippingPostalCode")
Newsletter=Request.Form("Newsletter")
If (Request.Form("Submit") <>"") Then
mytransfer="INSERT INTO CustomerList VALUES ('" & _
             FirstName & "', '" & _
             LastName &"', '" & Uname & "', '" & _
             Pass & "', '" & Email & "', '" & _
             PhoneNumber & "', '" & FavoriteNHLPlayer & "', '" & _
             ShippingAddress & "', '" & ShippingCity & "', '" & _
             ShippingProvince & "', '" & ShippingPostalCode & "', '" & _
             BillingAddress & "', '" & BillingCity & "', '" & _
             BillingProvince & "', '" & BillingPostalCode & "', '" & _
             Newsletter & "') "
Set rscustomers.Execute(mytransfer)
rscustomers.Close
End If
 
Set rscustomers = Nothing
Set objConn = Nothing
 
%>
 

Thanks in advance to any replies.

[nico5038]

Hard to diagnose from a distance, but here some links about using Access as a web enabled database:
http://members.optushome.com.au/anandasim/asp.htm#howdo
www.brinkster.com
Don't use Access on the web:
http://www.aspemporium.com/aspEmpori...seMSAccess.asp

In general I would check the required fields from the table before starting an INSERT.

Nic;o)

[Invisible Bunny King]

Nico,
Thanks for replying.
Boy, some of those links spooked me. Why not to use Access? Well, too late for that now...
Anyway, nothing in any of those links seemed to fix the problem. I tried a few other things, to no avail.
I have settled, for now, on an email form. I will manually enter the info into the database for now.
I think it's obvious that this is not the preferred method, but it will work 'til I get it working right.
Any other thoughts??

Hard to diagnose from a distance, but here some links about using Access as a web enabled database:
http://members.optushome.com.au/anandasim/asp.htm#howdo
www.brinkster.com
Don't use Access on the web:
http://www.aspemporium.com/aspEmpori...seMSAccess.asp

In general I would check the required fields from the table before starting an INSERT.

Nic;o)

[nico5038]

Checkout MS Access 2007 it has an email "datacollect" possibility and can store data on a SharePoint server.

Nic;o)

[Invisible Bunny King]

HI.
I looked into it. Yes, that is an option, but from my understanding, I can only do this if I send the email to people. The idea is that users go to a page on my site to register. Is there a way to make the Data collect work in this way?

Checkout MS Access 2007 it has an email "datacollect" possibility and can store data on a SharePoint server.

Nic;o)

[nico5038]

I'm no Sharepoint expert, but I would look into the possibilities of SharePoint.
It's specially designed for data exchange and easily linked to from Access.

Nic;o)