Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  Error in ASP re updateable query

Author  Topic  ian Starting Member 2 Posts Posted - 2001-01-25 : 07:30:15 Hi, I'm using an ASP page to take values from another ASP page an create a sql string which i want to use to create a new record in my Access 2000 db. I'm using the syntax: INSERT INTO (etc) VALUES ('etc'), which should work. The error I'm getting is: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. /Project4/EnterProg.asp, line 174 Line 174 in my ASP page is: myComm.Execute I know the SQL and ASP is fine. I've had others checking that, but I suspect it has something to do with my db permissions, but can't figure out what. The permissions seem fine to me. The reason I think it may be the permissions is that I tried re=writing the whole thing using recordsets, which brought up an error saying that the Database can't be written to. Any ideas? Please help!!