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
 Operation must use an updateable query problem! Proffessional Works, Advanced Server does not

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-05-06 : 09:13:10
Mike H writes "I have been running a website on Windows 2000 Professional, however since moving to Advanced Server, all of my SQL Insert commands seem to have stopped working, and produce the following error :

"Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/addfile2.asp, line 58"

That particular sql command looks like this :


sqlcode = "Insert into List VALUES('"&file&"','"&data&"','default')"
set rs3 = Conn3.execute(sqlcode)


rs3 is set as a connection, and it did work on 2k Pro, but on 2k Adv Server, it does not work, all of my insert commands wont work, the update and the select commands work fine. Can anybody help?

Mike"

Doug G
Constraint Violating Yak Guru

331 Posts

Posted - 2002-05-06 : 10:41:23
Almost always this error is due to insufficient permissions to the .mdb file. The user context of your code needs to have read/write permissions to the database file & folder.


======
Doug G
======
Go to Top of Page
   

- Advertisement -