writing to access db

[Edgar]

Hi,

I have an issue when trying to insert data into my Access DB thru ASP pages.

We have no issues using t-SQL SELECT statements, but when we try:

<%
oConn.Execute("INSERT INTO tComments(author,comments,ip,date) values('" & author & "','" & comments & "','" & ip & "', getdate())")
%>

But get this error:

"Microsoft JET Database Engine error '80040e14'

Syntax error in INSERT INTO statement."

So I tried this standard code:

<%
Set objrs1 = Server.CreateObject ("ADODB.Recordset")
objrs1.Open "tComments", strConnect,1,3,2
objrs1.AddNew
objrs1("Author") = author
objrs1("Comments") = comments
objrs1("IPAddress") = ip
objrs1("Date") = Date()
objrs1.Update
objrs1.Close
Set objrs1 = Nothing
%>

And get this error, despite me having check all permissions on the mdb via our FTP client:

"Microsoft JET Database Engine error '80040e09'

Cannot update. Database or object is read-only."

Any help would be greatly appreciated

[paulredpath]

Hi,

Is the database in the /db directory we provide?

[Edgar]

Ah, no, it should be? I'll get it moved
cheers

[paulredpath]

Yep