Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Operation must use an updatetable query
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Operation must use an updatetable query

 Post Reply Post Reply
Author
coolnlstuff View Drop Down
Newbie
Newbie
Avatar

Joined: 26 April 2003
Location: Netherlands
Status: Offline
Points: 14
Post Options Post Options   Thanks (0) Thanks(0)   Quote coolnlstuff Quote  Post ReplyReply Direct Link To This Post Topic: Operation must use an updatetable query
    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.

Back to Top
TYSON View Drop Down
Groupie
Groupie


Joined: 18 August 2002
Location: Australia
Status: Offline
Points: 142
Post Options Post Options   Thanks (0) Thanks(0)   Quote TYSON Quote  Post ReplyReply Direct Link To This Post Posted: 06 May 2003 at 5:05am
Is the database itself Read-only?
Back to Top
Bunce View Drop Down
Senior Member
Senior Member
Avatar

Joined: 10 April 2002
Location: Australia
Status: Offline
Points: 846
Post Options Post Options   Thanks (0) Thanks(0)   Quote Bunce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
coolnlstuff View Drop Down
Newbie
Newbie
Avatar

Joined: 26 April 2003
Location: Netherlands
Status: Offline
Points: 14
Post Options Post Options   Thanks (0) Thanks(0)   Quote coolnlstuff Quote  Post ReplyReply Direct Link To This Post 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!!!

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.