"Operation must be an updatable query"

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.
Who is Participating?
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
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.
Emanuele_CiriachiAuthor Commented:
Giving a try right now. Oh and the colon is just a typo, it is not present in the code.
Emanuele_CiriachiAuthor Commented:
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?
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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?

Emanuele_CiriachiAuthor Commented:
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.
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?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.