Weird ASP error when trying to add a new record to a MS Access database 
Author Message
 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



Fri, 15 Dec 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Trying to add new record to Access database

2. add new record to MS ACCESS database

3. DELETE Records in MS Access Database from ASP on XP Pro

4. Can't add new record to Access database with DataControl

5. Can't add new record to Access database with data control

6. add a new record into my Access database

7. trying to write a new record to an Access 97 table

8. How to add new records in a new database

9. Complicated Record Handling on MS Sql server and MS Accesses Databases

10. adding new records & new record

11. I need to be able to add new fields to a MS Access table via VbScript

12. Trying to get data from MS Access table (not using ASP)

 

 
Powered by phpBB® Forum Software