"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.
LVL 1
Emanuele_CiriachiAsked:
Who is Participating?
 
peter57rCommented:
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
 
Emanuele_CiriachiAuthor Commented:
Giving a try right now. Oh and the colon is just a typo, it is not present in the code.
0
 
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?
0
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.

 
peter57rCommented:
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
 
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.
0
 
CCongdonCommented:
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
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.