Read only database?

<i><b>Originally posted by : Marie Davis (mariedavis@hotmail.com)</b></i><br />I've got a db on a free web server (DSN-less connection). My connection works fine--I can search and get matches, but when I try to add to the database, I get the following message:<br /><br />Microsoft OLE DB Provider for ODBC Drivers error '80004005' <br /><br />[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only. <br /><br />I've tried using SQL statements to insert records and addnew/update without success. My code is fairly simple: addnew, put value x in field y, update. What am I doing wrong?<br /><br />Thanks in advance...<br /><br />Marie<br /><br />

<i><b>Originally posted by : Oleg (ole@beep.ru)</b></i><br />Hi, Marie<br />If you use MS Access under NT as database you have to set R/W permissions on this *.mdb file.<br />Try to look at permissions setting before you connect to database file via ADO (ODBC) driver. <br />It’ll get problems in multiuse environment too.<br /><br />Oleg Zakharov<br /><br /><br /><br />------------<br />Marie Davis at 5/11/2000 12:27:44 PM<br /><br />I've got a db on a free web server (DSN-less connection). My connection works fine--I can search and get matches, but when I try to add to the database, I get the following message:<br /><br />Microsoft OLE DB Provider for ODBC Drivers error '80004005' <br /><br />[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only. <br /><br />I've tried using SQL statements to insert records and addnew/update without success. My code is fairly simple: addnew, put value x in field y, update. What am I doing wrong?<br /><br />Thanks in advance...<br /><br />Marie<br /><br />

<i><b>Originally posted by : Marie Davis (mariedavis@hotmail.com)</b></i><br />Thanks for the advice, but I'm a little confused--do I set the db permissions before uploading to the site? How would I go about doing that? I've never altered them before in other situations (hooking to VB on a single machine).<br /><br />Thanks for your time....<br /><br />Marie<br /><br /><br />------------<br />Oleg at 5/11/2000 2:13:07 PM<br /><br />Hi, Marie<br />If you use MS Access under NT as database you have to set R/W permissions on this *.mdb file.<br />Try to look at permissions setting before you connect to database file via ADO (ODBC) driver. <br />It’ll get problems in multiuse environment too.<br /><br />Oleg Zakharov<br /><br /><br /><br />------------<br />Marie Davis at 5/11/2000 12:27:44 PM<br /><br />I've got a db on a free web server (DSN-less connection). My connection works fine--I can search and get matches, but when I try to add to the database, I get the following message:<br /><br />Microsoft OLE DB Provider for ODBC Drivers error '80004005' <br /><br />[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only. <br /><br />I've tried using SQL statements to insert records and addnew/update without success. My code is fairly simple: addnew, put value x in field y, update. What am I doing wrong?<br /><br />Thanks in advance...<br /><br />Marie<br /><br />

<i><b>Originally posted by : Oleg (ole@beep.ru)</b></i><br /><br />1.) I’m saying about permissions on the *.mdb file(!) that you connect, but not database properties.<br />Network administrator has to set the file permissions to allow to write in and to change it.<br />PS.<br />If you will open that file as database from MS Access directly (not from ASP code) try to check this permissions again.<br /><br />2.) When you connect to database from ASP code - this is only one user (‘anyone’ for NT server) for MS Access driver. So, close opened connection before open a new one.<br /><br />Hope, help to you….<br /><br /><br />------------<br />Marie Davis at 5/11/2000 4:34:18 PM<br /><br />Thanks for the advice, but I'm a little confused--do I set the db permissions before uploading to the site? How would I go about doing that? I've never altered them before in other situations (hooking to VB on a single machine).<br /><br />Thanks for your time....<br /><br />Marie<br /><br /><br />------------<br />Oleg at 5/11/2000 2:13:07 PM<br /><br />Hi, Marie<br />If you use MS Access under NT as database you have to set R/W permissions on this *.mdb file.<br />Try to look at permissions setting before you connect to database file via ADO (ODBC) driver. <br />It’ll get problems in multiuse environment too.<br /><br />Oleg Zakharov<br /><br /><br /><br />------------<br />Marie Davis at 5/11/2000 12:27:44 PM<br /><br />I've got a db on a free web server (DSN-less connection). My connection works fine--I can search and get matches, but when I try to add to the database, I get the following message:<br /><br />Microsoft OLE DB Provider for ODBC Drivers error '80004005' <br /><br />[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only. <br /><br />I've tried using SQL statements to insert records and addnew/update without success. My code is fairly simple: addnew, put value x in field y, update. What am I doing wrong?<br /><br />Thanks in advance...<br /><br />Marie<br /><br />

<i><b>Originally posted by : Marie Davis (mariedavis@hotmail.com)</b></i><br />I checked the permissions, and the database is set to give the admin read, write, update, modify, ... rights. I've only got one user in the system now to test it, so presumably that one person has admin rights as a default.<br /><br />I appreciate your help. I'm going to speak directly to my host to determine how to solve my problem.<br /><br />Have a great day!<br /><br />Marie<br /><br />------------<br />Oleg at 5/11/2000 6:12:12 PM<br /><br /><br />1.) I’m saying about permissions on the *.mdb file(!) that you connect, but not database properties.<br />Network administrator has to set the file permissions to allow to write in and to change it.<br />PS.<br />If you will open that file as database from MS Access directly (not from ASP code) try to check this permissions again.<br /><br />2.) When you connect to database from ASP code - this is only one user (‘anyone’ for NT server) for MS Access driver. So, close opened connection before open a new one.<br /><br />Hope, help to you….<br /><br /><br />------------<br />Marie Davis at 5/11/2000 4:34:18 PM<br /><br />Thanks for the advice, but I'm a little confused--do I set the db permissions before uploading to the site? How would I go about doing that? I've never altered them before in other situations (hooking to VB on a single machine).<br /><br />Thanks for your time....<br /><br />Marie<br /><br /><br />------------<br />Oleg at 5/11/2000 2:13:07 PM<br /><br />Hi, Marie<br />If you use MS Access under NT as database you have to set R/W permissions on this *.mdb file.<br />Try to look at permissions setting before you connect to database file via ADO (ODBC) driver. <br />It’ll get problems in multiuse environment too.<br /><br />Oleg Zakharov<br /><br /><br /><br />------------<br />Marie Davis at 5/11/2000 12:27:44 PM<br /><br />I've got a db on a free web server (DSN-less connection). My connection works fine--I can search and get matches, but when I try to add to the database, I get the following message:<br /><br />Microsoft OLE DB Provider for ODBC Drivers error '80004005' <br /><br />[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only. <br /><br />I've tried using SQL statements to insert records and addnew/update without success. My code is fairly simple: addnew, put value x in field y, update. What am I doing wrong?<br /><br />Thanks in advance...<br /><br />Marie<br /><br />