Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - 7 to 8 convert error= in a read-only database
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

7 to 8 convert error= in a read-only database
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
SteelWolf View Drop Down
Newbie
Newbie


Joined: 31 May 2006
Status: Offline
Points: 2 		Post Options Post Options   Thanks (0) Thanks(0)   Quote SteelWolf Quote  Post ReplyReply Direct Link To This Post Topic: 7 to 8 convert error= in a read-only database
    Posted: 31 May 2006 at 2:41pm
Following the instructions and adding my own of reinstalling the common file after i was done  the conversion came up with this.  This file was pulled right from the server with no editing and was waorking and accepting input just fine.  It was front page 2002 that was handeling the upload and download. I dont see how the file suddenly became write protected.
 
 

Web Wiz Forums Database Microsoft Access v7.x to v8 Update


This tool is to update a Web Wiz Forums version 7.x to version 8 Access Database



Database Updated Started

Stage 1: Database Connection..... Complete

Stage 2: Creating New Database Tables and Fields.....
Error Updating the Table tblForum
Cannot modify the design of table 'tblForum'. It is in a read-only database.


Error Updating the Table tblTopic
Cannot modify the design of table 'tblTopic'. It is in a read-only database.


Error Update the Table tblThread
Cannot modify the design of table 'tblThread'. It is in a read-only database.


Error Updating the Table tblPermissions
Cannot modify the design of table 'tblPermissions'. It is in a read-only database.


Error Altering the Table tblAuthor
Cannot modify the design of table 'tblAuthor'. It is in a read-only database.


Error Altering the Table tblConfiguration
Cannot modify the design of table 'tblConfiguration'. It is in a read-only database.


Error Altering the Table tblDateTimeFormat
Cannot modify the design of table 'tblDateTimeFormat'. It is in a read-only database.


Error Creating the Table tblPollVote
Cannot modify the design of table 'tblPollVote'. It is in a read-only database.


Error Creating the Table tblSession
Cannot modify the design of table 'tblSession'. It is in a read-only database.

Complete

Stage 3: Entering default values for new fields.....
Error entering default values in the Table tblForum
No value given for one or more required parameters.


Error entering default values in the Table tblAuthor
No value given for one or more required parameters.


Error entering default values in the Table tblDateTimeFormat
No value given for one or more required parameters.


Error entering default values in the Table tblConfiguration
No value given for one or more required parameters.

Complete

Stage 4: Populating Database with Default Forum Permissions (this may take some time to complete).....
Permissions are reset to original defaults, you may need to update them once the upgrade is complete.
Complete

Stage 5: Populating Database with Forum Statistics (this may take some time to complete).....Complete

Stage 6: Populating Database with Topic Statistics (this may take some time to complete)..... Complete

Error Discription: No value given for one or more required parameters.


Access database is updated, but with Error!

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 31 May 2006 at 3:44pm
This is a server permissions problem.

You need to make sure you have the correct permissions set on the server to be able to write to the Access database.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
SteelWolf View Drop Down
Newbie
Newbie


Joined: 31 May 2006
Status: Offline
Points: 2 		Post Options Post Options   Thanks (0) Thanks(0)   Quote SteelWolf Quote  Post ReplyReply Direct Link To This Post Posted: 01 June 2006 at 11:50pm
Ok i talked to my host provider. He tells me that if the database had been opened by a means other then the following it changes the paramiters inside the DB.
1>connect to the Server with front page.
2> use FP to open the database which passes it alonf to acces wich in turn actually does the opening.
 
about 7 weeks ago i opened a copy, on my desktop, of the database with access. I later uploaded the updated databas and the forums worked fine for the next 7 weeks.   What prombted my wanting to upgrade to 8.? is the 7.0 forums were starting to get errors and i had not updated in a while. The latest error for example. and still up at http://www.darkcontinuum.com/forum
 
 
 

Microsoft JET Database Engine error '80040e09'

Cannot update. Database or object is read-only.

/forum/login_user.asp, line 171

 
Even with a 3 month old back up databast i have never opened i still get the write errors. and the provider has checked a couple times the folder and file permissions for me.
 
Thanks.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 02 June 2006 at 9:23am
This is the same error as you printed in your first post here.

Again, this is a permissions problem, meaning that you can not write to the database becuase the database is set to have only the 'Read' permission set, thus it is 'Read Only' you need to also have write a modify permissions on the database.

Frontpage is always a big problem, and quite often courses issues with ASP applications.

When you have Frontpage extenisons installed you need to use Frontpage to upload to your site to keep the Frontpage extensions instact, if you use FTP to upload it can mess up the whole thing.

You need to contact your web host to get them to correct this permissions problem.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.