
Weird ASP error when trying to add a new record to a MS Access database
I am pulling my hair out trying to solve a problem in one of my ASP pages.
I keep on getting the following error when trying to add a new record:
------
error 'ASP 0115'
Unexpected error
/mbazone/before/AddBeforeLink.asp
A trappable error occurred in an external object. The script cannot continue
running.
------
Here is the code I am using to add the record:
Set rs = Server.CreateObject("ADODB.Recordset")
%>Here<% rs.Open "Before Links", "mbazone", adOpenKeySet, adLockOptimistic,
adCmdTable
%>Here2<% rs.AddNew
%>Here3<% rs.Fields("Area") = CStr(Request.Form("dropArea"))
%>Here4<% rs.Fields("LinkName") = "MBA ZoNe"
%>Here5<% rs.Fields("Link") = CStr(Request.Form("txtLink"))
%>Here6<% rs.Fields("Name") = CStr(Request.Form("txtName"))
%>Here7<% rs.Fields("Email") = CStr(Request.Form("txtEmail"))
%>Here8<% rs.Fields("Description") = CStr(Request.Form("txtDesc"))
%>Here9<% rs.Fields("Rating") = CInt("dropRating")
%>Here10<% rs.Fields("Date") = Cstr(Date())
%>Here11<% rs.Update
rs.Close
Set rs = Nothing
I have tried various debugging techniques but I have not been able to
pinpoint the problem.
Do you have any idea what could be causing this?
Thanks,
Brett