Operation must use an updateable query??

[cyprus106]

I'm getting this error after I try to add to a table in my database theough the code below

Error:
Operation must use an updateable query.

My Code:
set conn = Server.CreateObject("ADODB.connection&quot
sConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & server.mappath("betaboard.mdb&quot &_
"; Persist Security Info=False"
conn.Open(sConnection)

sqlstring = "INSERT INTO board ( [date], topic, name, email, http, body ) " &_
"values ( # " & now() & " #, ' " & topic & " ' , ' " & name & " ' , ' " & email & " ', ' " & http & " ' , ' " & body & " ')"
conn.Execute(sqlstring)
conn.Close

I have absolutely no idea what's wrong, having not been very experienced in asp. Could someone please help me? I'm just taking a few values inputted by a user and assing them to a table and it won't let me!

Thanks lots... Cyprus

 

[baddos]

Make sure that the access database is able to be modified by the Internet guest account. It might be that file security on your webserver doesn't allow the internet guest account to modify that file.

 

[cyprus106]

It's just a file sitting on my website, it's not off an SQL server or anything. Does that matter? Cyprus

 

[mapnapkin]

it's just that your host has to set Iuser permission to write so the internet user can modify the database
if you contact them they will know give them the database name and path to the db and they will fix that

 

[cyprus106]

yea, I noticed. thanks guys Cyprus