Problem with update statement.
-
Hello there guys. I have a problem with an update statement.Im have an intranet site from work that I copied and tried to upload on my home machine.The problem is when I try to login....I get this error on the update quesry. Whenever someone logs in, the database is updated to see who logged in at what time. I get this error "Error #214767259 Operation must use an Updateable Query" SQL = UPDATE tbl_employees SET lastlogin = "" Where employeelogin = "" The problem was may have been write rights to write onto the database, but the files are on my Inetput folder, so it cant be that.I checked the rights and its not that. What else could be the problem. Thanx in advance guys.
kagiso
-
Hello there guys. I have a problem with an update statement.Im have an intranet site from work that I copied and tried to upload on my home machine.The problem is when I try to login....I get this error on the update quesry. Whenever someone logs in, the database is updated to see who logged in at what time. I get this error "Error #214767259 Operation must use an Updateable Query" SQL = UPDATE tbl_employees SET lastlogin = "" Where employeelogin = "" The problem was may have been write rights to write onto the database, but the files are on my Inetput folder, so it cant be that.I checked the rights and its not that. What else could be the problem. Thanx in advance guys.
kagiso
Have you seen this article? http://support.microsoft.com/kb/175168[^]
Mark's blog: developMENTALmadness.blogspot.com