Updateable queries
-
I've just upgraded to XP Pro/IIS from Win98/PWS. I put my website in wwwroot, changed the permissions on the database folder to 'read and write' so I can modify my databases (Access 2000). But alas, I get a 'query must be updateable' error! I went into the wwwroot folder using explorer and went to the databases folder's properties. I don't have a 'security' tab (Am I supposed to? I do on W2K) and I can't uncheck the readonly option! My queries are like: UPDATE table SET field1='value1', field2='value2' WHERE ID = myid INSERT INTO table (field1, field2) VALUES ('value1', 'value2') Has anyone had any problem similar to this or have any ideas? I'm stuck. - X
-
I've just upgraded to XP Pro/IIS from Win98/PWS. I put my website in wwwroot, changed the permissions on the database folder to 'read and write' so I can modify my databases (Access 2000). But alas, I get a 'query must be updateable' error! I went into the wwwroot folder using explorer and went to the databases folder's properties. I don't have a 'security' tab (Am I supposed to? I do on W2K) and I can't uncheck the readonly option! My queries are like: UPDATE table SET field1='value1', field2='value2' WHERE ID = myid INSERT INTO table (field1, field2) VALUES ('value1', 'value2') Has anyone had any problem similar to this or have any ideas? I'm stuck. - X
Xavier Shay wrote: I don't have a 'security' tab (Am I supposed to? I do on W2K) and I can't uncheck the readonly option I'm in my W2K now but as I remember you have to go to folder options--->View Then I think one of the last options change the simple security to other ones,then you have 'security tab' in xp too. Mazy **"If I go crazy then will you still Call me Superman If I’m alive and well, will you be There holding my hand I’ll keep you by my side with My superhuman might Kryptonite"**Kryptonite-3 Doors Down
-
I've just upgraded to XP Pro/IIS from Win98/PWS. I put my website in wwwroot, changed the permissions on the database folder to 'read and write' so I can modify my databases (Access 2000). But alas, I get a 'query must be updateable' error! I went into the wwwroot folder using explorer and went to the databases folder's properties. I don't have a 'security' tab (Am I supposed to? I do on W2K) and I can't uncheck the readonly option! My queries are like: UPDATE table SET field1='value1', field2='value2' WHERE ID = myid INSERT INTO table (field1, field2) VALUES ('value1', 'value2') Has anyone had any problem similar to this or have any ideas? I'm stuck. - X
Yep, Mazdak is right, I'm replying just to say - I remember how I spent a whole day trying to find where the damn security tab is in XP, lmao. Nostalgy :) Philip Patrick Web-site: www.stpworks.com "Two beer or not two beer?" Shakesbeer
-
I've just upgraded to XP Pro/IIS from Win98/PWS. I put my website in wwwroot, changed the permissions on the database folder to 'read and write' so I can modify my databases (Access 2000). But alas, I get a 'query must be updateable' error! I went into the wwwroot folder using explorer and went to the databases folder's properties. I don't have a 'security' tab (Am I supposed to? I do on W2K) and I can't uncheck the readonly option! My queries are like: UPDATE table SET field1='value1', field2='value2' WHERE ID = myid INSERT INTO table (field1, field2) VALUES ('value1', 'value2') Has anyone had any problem similar to this or have any ideas? I'm stuck. - X
Xavier Shay wrote: ). But alas, I get a 'query must be updateable' error! I went into the wwwroot folder using explorer and went to the databases folder's properties. Have you set up your DB connection using ODBC? Putting your database in the wwwroot folder and hard coding the path is not a good idea. The reason I suspect you are getting this error is because you didn't set up connectivity with ODBC, and your database has a security level that is higher then the default IIS account so it won't allow read/write access. To change this either 1. Set up a ODBC connection(the right way) or 2. make your Access Database security level one that the default IIS account can use(the dangerous way).
-
Xavier Shay wrote: I don't have a 'security' tab (Am I supposed to? I do on W2K) and I can't uncheck the readonly option I'm in my W2K now but as I remember you have to go to folder options--->View Then I think one of the last options change the simple security to other ones,then you have 'security tab' in xp too. Mazy **"If I go crazy then will you still Call me Superman If I’m alive and well, will you be There holding my hand I’ll keep you by my side with My superhuman might Kryptonite"**Kryptonite-3 Doors Down
You're exactly right, thanks :) - X
-
Xavier Shay wrote: ). But alas, I get a 'query must be updateable' error! I went into the wwwroot folder using explorer and went to the databases folder's properties. Have you set up your DB connection using ODBC? Putting your database in the wwwroot folder and hard coding the path is not a good idea. The reason I suspect you are getting this error is because you didn't set up connectivity with ODBC, and your database has a security level that is higher then the default IIS account so it won't allow read/write access. To change this either 1. Set up a ODBC connection(the right way) or 2. make your Access Database security level one that the default IIS account can use(the dangerous way).
I have to upload my site to a remote server which I don't have much control over, and as such I don't think I can use ODBC connection names (I don't know much about them, correct me if I'm wrong). I have the databases stored in a subdirectory (wwwroot/databases) and I am going to try and change the security permissions on this database. I'm not the right comp to try this now (it's at work) but I'll post what code I'm using as soon as possible. Thanks for your help :) - X