Adding Record to *.mdb With ASP

[dndstef]

Well i'm troubled.

I've created an ASP web site that's accessing an Access97
Database and it works fine on my frontpage Server but on
the my AtFreeWeb.com site when i'm trying to add record i
have this Error MSG but a can read the database.


Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.

/Fin.asp, line 48


At the line 48 i'm doing the update of the Recordset
~
line 46 Recordset.AddNew
line 47 Recordset("Field1") = Request("Field1")
line 48 Recordset.update
~

But on the webserver it gives me that Error while at home
it works ok.

Can someone help me?

[Mark Sreeves]

personally I prefer to use the SQL INSERT command


strSQL = "INSERT into tablename(fieldname) VALUES ('" & data & "');"
conn.Execute(strSQL)


So sorry, I can't help! :)

[Ianpbaker]

hi dndstef

From what I can remember, some hosting companies make all files read-only once they have been uploaded, to make it harder for would be hackers to change your site. This could be your problem.

Hope this helps

Ian

[thinh]

I've came to the same problem with this once, but i don't know if you have the same problem. ASP input to MSAccess will regconized the """ and "'" to be special command for it. So you might want to add some codes which will change the """ to something like ":::" and "'" to something like ";;;" and then add to the database. when read to database you need some codes to change the ":::" and ";;;" back to """ and "'"...

I hope this will help solve your problem...