server error updating access database.. WHY?

**numbenator** · 11:29 AM

Hi all,

I am getting an error on the below :

Im a little confused as to why though. If i remove the line
rs.Fields("studentName") = request.form("studentName")
& rs.Update
then i have no error. Could someone please give me some direction.

Code:

 
<% response.Expires=0 %>
 
 
 
<!--#include file="SSI/_conn.asp"-->

<%   Dim rs, updateSQL
     Set rs = Server.CreateObject("ADODB.RecordSet")
	    updateSQL = "SELECT * FROM comments"	    
	    rs.open updateSQL, Conn
		rs.MoveFirst
			rs.Fields("studentName")  = request.form("studentName")
		rs.Update
		rs.Close   
%>

**Minaki** · 08-11-2005, 11:54 AM

What exactly are you trying to do? What error message are you getting?

**numbenator** · 08-11-2005, 11:56 AM

I have a form from where i retrieve info.
I then check it's validity then go a a save page.
I simply wish to update the form to the database.

http://www.mastech-solutions.com/Stu...ce/collect.asp

Im not that good at asp so have a standard browser server error. Not sure how to put a proper error page in
cheers.

**Anacrusis** · 08-11-2005, 02:26 PM

Make sure your database file and the folder it is in both have write permissions on the server.

**chrishirst** · 08-11-2005, 02:53 PM

You are not using an updateable locktype. The default is read only.

Code:

rs.open updateSQL, Conn, adOpenkeyset, adLockOptimistic

**numbenator** · 08-11-2005, 03:02 PM

ok. thats helped together with adding permissions to the directory. cheers

**Minaki** · 08-12-2005, 03:48 AM

Quote:

Im not that good at asp so have a standard browser server error. Not sure how to put a proper error page in

It could be the way your browser is set up. Go to Tools - Options, go to the Advanced tab, and make sure 'Show Friendly HTTP Error Messages' is not checked.

**numbenator** · 08-12-2005, 04:57 AM

yeah have that flag set ok. Im actually reading up on proper error catching now. Figured that would
help lol.
cheers for allyour help. Always appreciated.
Steve