MarjaR wrote: thekiwi wrote: Nope ... its purely a problem at your host (assuming the database transfers OK etc). WHilst one database may be working OK already ... they will need to make sure your new database has change/modify as well as write access. I've checked with an online DB admin tool and that tool tells me that the MDB file is indeed read-only. Strange.... I will contact my hosting provider to ask them to check the file access permissions on that MDB. Thanks for your help.

No worries.  ONe of those weird things with Windows Servers .... Ive even just checked a folder I have setup which has full MOdify access  ... and there are files in there which are read only!

Good to hear it will hopefully be sorted out.

thekiwi wrote: Nope ... its purely a problem at your host (assuming the database transfers OK etc). WHilst one database may be working OK already ... they will need to make sure your new database has change/modify as well as write access.

I've checked with an online DB admin tool and that tool tells me that the MDB file is indeed read-only. Strange....

I will contact my hosting provider to ask them to check the file access permissions on that MDB.

Thanks for your help.

MarjaR wrote: thekiwi wrote: Yes ... but that doesn't 100% ensure that the database itself is read/write.  The only 100% way to ensure this (trust me .. I run a hosting service and it happens often) is to TermServ in or be at the console and chekc the privs of the MDB file. Okay, but this site is externally hosted so I can't do what you describe here. I've checked the MDB file properties here locally before uploading it and it isn't read-only here on my computer. Can it become read-only in the FTP process?

Nope ... its purely a problem at your host (assuming the database transfers OK etc).

WHilst one database may be working OK already ... they will need to make sure your new database has change/modify as well as write access.

shadow man wrote: you're only supposed to change the name of the database.

No you're not

http://www.webwiz.net/web_wiz_forums/docs_access_move_d b.asp?mode=forum

"For higher security it is highly recommended that you at the very least rename the forum database and if possible move the location of the database to a folder above the root directory of your web site where it can not be accessed using a web browser, good web hosts will have a directory set up for this usually called private. (If you don't you leave yourself wide open to hackers!!)"

thekiwi wrote: Yes ... but that doesn't 100% ensure that the database itself is read/write.  The only 100% way to ensure this (trust me .. I run a hosting service and it happens often) is to TermServ in or be at the console and chekc the privs of the MDB file.

Okay, but this site is externally hosted so I can't do what you describe here.

I've checked the MDB file properties here locally before uploading it and it isn't read-only here on my computer.
Can it become read-only in the FTP process?

MarjaR wrote: I placed the WebWiz MDB file in the same directory as where my main website MDB file resides. And I have no problem whatsoever updating my website DB using my CMS. I've tried re-uploading the forum DB several times now (to try to make sure it wasn't corrupted in the FTP process), but it doesn't help.

Yes ... but that doesn't 100% ensure that the database itself is read/write.  The only 100% way to ensure this (trust me .. I run a hosting service and it happens often) is to TermServ in or be at the console and chekc the privs of the MDB file.

I placed the WebWiz MDB file in the same directory as where my main website MDB file resides.
And I have no problem whatsoever updating my website DB using my CMS.

I've tried re-uploading the forum DB several times now (to try to make sure it wasn't corrupted in the FTP process), but it doesn't help.

MarjaR wrote: This database directory is outside the website root and is thus a safer place for a database.

Yes ..... it should almost be "required" that the database is moved outside the scope of the WWW Site.  Sure renaming it is a good idea .... but nothing is more secure than it being almost impossible to "reach" for download.

MarjaR wrote: Hi, I just uploaded the forum files to my website and tried to login with the Administrator account. However, it's not working. The error is the infamous 'updateable query' error, but I'm very certain that the directory where I put the forum database has the proper access rights, because my regular website database "lives" there as well. I'm positive (checked, double-checked and re-checked again) that I've changed the 2 common.asp files so that the DB path looks like: strDbPathAndName = "d:\www\flevooware.nl\database\wwForum.mdb" And I know for certain that I've uploaded them as well. So what else could be wrong? Regards, Marja BTW. the forum is located here: http://www.flevooware.nl/dreamweaver/forum/

 This is almost always a permissions issue.

Be sure that the MDB file is in a folder where IUSR has read/write access (because IUSR_<machine_name> needs to create an .LDB file when modifying the database).

Also be sure that the MDB file itself isn't marked as read-only, and that you don't have the MDB file open (particularly in exclusive mode) while trying to reach the DB from ASP