Solved

"Operation must be an updatable query"

Posted on 2007-12-05
6
421 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
  • 3
  • 2
6 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 500 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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

770 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