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/ - http://www.flevooware.nl/dreamweaver/forum/

But that's in the installation guide and it is correct that it is needed if the database is not in the default forum location.

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

Anyway, there are instructions on moving and/or renaming the WebWiz DB if needed ( http://www.webwiz.net/web_wiz_forums/docs_access_move_db.asp?mode=asp - http://www.webwiz.net/web_wiz_forums/docs_access_move_ db.asp?mode=asp ), and that's what I need to do.
It's just not working the way it should.

Thank you for your replies, but that's really not the only thing I need to do.
Please read the official instructions at http://www.webwiz.net/web_wiz_forums/docs_access_move_db.asp?mode=asp - http://www.webwiz.net/web_wiz_forums/docs_access_move_ db.asp?mode=asp  to see what I'm trying to do: placing the MDB file outside the website itself.

No, not to another website... just outside the website directory structure.

My domain is set up as follows:

• FTP-root
• database
• www

My website root is the 'www' directory, while the database is in the directory named 'database'.

This is really a very common domain setup.

move the "forum" folder to /www/forum/. then

if it is there, for the common.asp in the "forum" directory, change to have:

strDbPathAndName = "..\database\wwForum.mdb"

Same error with relative paths (the Server.MapPath method)

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/ - 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

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.

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: 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.

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?

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_db.asp?mode=forum - 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!!)"

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.

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: 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.