Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

"Operation must be an updatable query"

Posted on 2007-12-05
6
Medium Priority
?
460 Views
Last Modified: 2008-02-01
I know this error is quite common, but I find myself unable to make it work online - while on my local machine it works perfectly. The query is the following:

------------------

UPDATE tblRooms SET [Active] = false WHERE day >= #10/01/2008# AND day < #11/'1/2008# AND hotelID = 1

------------------

I get the error "Operation must be an updatable query" on the execution of this query.
Table has:

ID - autonumber
typeID - number
hotelID - number
day - Date/Time
bookingID - number
active - boolean

The db folder has write access, before anyone asks me.
0
Comment
Question by:Emanuele_Ciriachi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 2000 total points
ID: 20410552
If this is an exact copy of your code :
UPDATE tblRooms SET [Active] = false WHERE day >= #10/01/2008# AND day < #11/'1/2008# AND hotelID = 1
then
1) you have a spurious ' in the date value
2) day is a reserved word and should be enclosed in [ ] to indicate it is your field name.
0
 
LVL 1

Author Comment

by:Emanuele_Ciriachi
ID: 20410644
Giving a try right now. Oh and the colon is just a typo, it is not present in the code.
0
 
LVL 1

Author Comment

by:Emanuele_Ciriachi
ID: 20410699
no, doesn't work...

The database is remote, and I can read it using Select, no problem. Also, I left it without any sort of password protection. Does this rings a bell?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 77

Expert Comment

by:peter57r
ID: 20410852
Then it looks to me that the problem is not the query but is something to do with the connection.
When you say 'make it work online '
what exactly does that mean?  Are you on a LAN or trying to run across a WAN or what?
Can you change any other value in the database directly from your front end app?

0
 
LVL 1

Author Comment

by:Emanuele_Ciriachi
ID: 20410891
I can run everything fine on my machine, but on the web server I can only run SELECT.

I am connected to Internet and have all sort of access to the we server. The DB folder has read/write permissions, of course.
0
 
LVL 9

Expert Comment

by:CCongdon
ID: 20411976
OK, so the DB *folder* has read/write permissions, but what about the DB *file*? Is it set to inherit permissions from the folder? Is the folder set to propogate permissions to children? Does the file have an explicit deny on it? Is there a <dbname>.LDB file in the directory (a lock file)? Are you sure the correct user has the permissions?
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question