[thelist] SQL INSERT Trouble...

[Adam Slesinger]

Hi All.  I'm seting up my first database and am having trouble with
inserting a new row into my table.  I'm using asp on IIS with a msaccess db.
  I've grabbed and displayed records in my page just fine, but when i try
and update the table with a new row, I get this error message from IE6:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.
/registration.asp, line 58

Here is the syntax I used:

SQL="INSERT INTO register (Name, Email, Handle, Clan, Age, Region, Agree,
Game01, Game02, Game03, Quote, Secured) VALUES ("
SQL=SQL & "'" & strName & "', "
SQL=SQL & "'" & strEmail & "', "
SQL=SQL & "'" & strHandle & "', "
SQL=SQL & "'" & strClan & "', "
SQL=SQL & "'" & strAge & "', "
SQL=SQL & "'" & strRegion & "', "
SQL=SQL & "'" & strAgree & "', "
SQL=SQL & "'" & strGame01 & "', "
SQL=SQL & "'" & strGame02 & "', "
SQL=SQL & "'" & strGame03 & "', "
SQL=SQL & "'" & strQuote & "', "
SQL=SQL & "'" & strSecured & "')"

set conn = server.createobject("ADODB.Connection")
conn.open "register"
set signedup=conn.execute(SQL)

I thought the syntax loooked OK - can anyone figure out what I'm doing
wrong?  I'm still new to this and the error messages can be a little
cryptic.

Thanks so much!!

ada aka bread_man
http://www.thebadlans.net

_________________________________________________________________
Join the world’s largest e-mail service with MSN Hotmail.
http://www.hotmail.com