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 !