[thelist] Update to an Access Database PLEASE HELP!!

[Chris Blessing]

Casey-

First off, for the insert statement you should use the .execute() method rather than opening a recordset.  There's no need to do that.  So change it from:

sql = sql & "VALUES('"& logOnUser &"','Customer Portal', '"&
cusp_status &"','" & cusp_reason & "', #"& timestamp &"#);"

 Call oRs.Open(sql, oConn, adOpenStatic, adLockReadOnly)

To:

sql = sql & "VALUES('"& logOnUser &"','Customer Portal', '"&
cusp_status &"','" & cusp_reason & "', #"& timestamp &"#);"

oConn.execute sql

And for the error line, are you sure cusp_status is being set?  Try response.writing it or msgbox'ing it (this looks like VB to me, yes?).

Chris Blessing
webguy at mail.rit.edu
http://www.330i.net

>
> Hello all,
>
> Asking the same question with a different subject as I got no response
> last time.  I sure could use the help!!  I'm trying to do a simple
> update to an Access database, and I can't get the silly thing to work.
> I know it's something simple, but all-be-darned if I can sniff it out.
>
> Here's what I've got (lots of carrage returns to keep lines from
> rendering correctly in email, but it's an easy read!):
> > Workers of the Web, evolt !