I am trying to set up an update page for a Access DB. I used the "Insert Application Object" "Update Record Form" to set it up. When I post it and try to update a record I get the reply below (an HTTP 500 error).
____________
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

/xxxx/Project_Update_Page_PPA.asp, line 45
___________________

Line 45 in the code reads: MM_editCmd.Execute();

Any one know what I am doing wrong?
DW8, XP, ASP, Access
John

Edited by - JaxJLJ on 21 Feb 2007 17:10:47

There are various reason you get this error. Start by making sure your permissions for Users are set to write. If that doesn't work we can think of something else. Also, if you are using ODBC connection I would suggest to change to DSN-less connection, it is much better.

See this:
www.webthang.co.uk/tuts/tuts_dmx/gk_cons/cons.asp
www.stardeveloper.com/articles/display.html?article=2000120101&page=1

I have a very good relationship with the gentleman who provides hosting for my website. He has set the permissions for the *.mdb files to allow write for all. (I have also asked him to set the entire folder where they are located to the same.)
I tried again to update, but no joy.
If there is anything I can provide, like code, let me know. I can not provide the actual db or viewing of it because of the proprietary of it.

Thanks,
JohnJ

Quote

There are various reason you get this error. Start by making ...

Look at this links:
www.thescripts.com/forum/thread54113.html
support.microsoft.com/kb/175168

Otay, the world is now again spinning in the right direction. Sat down with my ISP and helped him set up the folder as described on this forum. Started using DSN-less connection strings and now...smooth sailing. Or at least as smooth as you can get till the next problem.
Thanks all,
J