Database Discussion - Operation must use an updatetable query

Print Page | Close Window

Operation must use an updatetable query

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=2456
Printed Date: 30 March 2026 at 3:54am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Operation must use an updatetable query

Posted By: coolnlstuff
Subject: Operation must use an updatetable query
Date Posted: 06 May 2003 at 3:14am

I got the following error when trying to insert some data into a database.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/toets/include/functions.asp, line 209

I just moved my site to another pc with WinXP Pro and ISS and since then i get the error. I didn't get it on my old pc with the same specifications. I set the database directory to allow:
script source acces, read and write
The same as before..

So whats the problem? Can anyone help me.

Replies:

Posted By: TYSON
Date Posted: 06 May 2003 at 5:05am

Is the database itself Read-only?

-------------
http://www.fuo-motorsports.com/ - http://www.fuo-motorsports.com/

Posted By: Bunce
Date Posted: 06 May 2003 at 5:24am

Read the Database FAQ on this site and follow the steps word for word. That should fix your problem.

Cheers,
Andrew

-------------
There have been many, many posts made throughout the world...
This was one of them.

Posted By: coolnlstuff
Date Posted: 06 May 2003 at 6:38am

Yes thanx...I had set up the write permissions in IIS, but forgot to do it for the folder in Windows Explorer...

Thank you a lot!!!