Emanuele_Ciriachi
asked on
"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.
------------------
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
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?
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?
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?
ASKER
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.
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?
ASKER