|
-
March 6th, 2002, 09:53 AM
#1
Help sql insert
I am trying to insert into a table in my Acess database through a form in my asp page... ive got the code right but when I run it I get the following error message
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/nemendur/thormundurh/default.asp, line 46
this is my connection and sql line :
dim rsRU
Dim cnRU, sConnString
Set cnRU= Server.CreateObject("ADODB.Connection")
sConnString = "DRIVER={Microsoft Access Driver (*.mdb)};" & _
"DBQ=" & Server.MapPath("\nemendur\thormundurh\db\tolvunord.mdb") & ";"
cnRU.Mode = 3 '3 = adModeReadWrite
cnRU.Open(sConnString)
cnRU.Execute("INSERT INTO Umraedan values(1, '" &nafn & "', '" &email & "', '" &homesite & "', '" &text & "')")
please help...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|