From Version 7 to 8

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
jackals Members Profile Find Members Posts Groupie Joined: 27 June 2005 Location: United Kingdom Status: Offline Points: 66	Post Options Post Reply Quote jackals Report Post Thanks(0) Quote Reply Topic: From Version 7 to 8 Posted: 23 September 2006 at 2:16pm
	Hiya Guys - Gals I've been using webwiz for a few years know i'm still on version 7. Just had a look at version 8 and it seems to be that little higher with more options and more colour in the basic site. Is it possible to change my msaccess db to a mysql db? because i've been told its like a sitting time bomb on msaccess with the amount of users i have... Is this true??? also Is there an option to set up banners at the the top of the gforum like on this forum? I've downloaded the program that will let me update the website.... but it looks to be eather for ms access or mysql. Cheers Jack www.pwcforums.co.uk Edited by jackals - 23 September 2006 at 2:18pm

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 23 September 2006 at 6:58pm
	First you will need to download the Access version 7 to version 8 upgrade tool and follow the instructions in that file to upgrade your database to version 8. Once this is done you can consider attempting to move to a new database type, but it can be tricky but it seems that the Access to mySQL tools available from mySQL are easier to use then trying to migrate from Access to SQL Server. Using Access is always dangerous as access is simply a flat office file and not a database management system so easily becomes corrupted if you have more than a handful of users. If you decide to go down the mySQL conversion root before making the database migration to mySQL you will need to delete the field tblPermissions -> Read in the database as this is a version 7 field that is not compatible with mySQL so was removed in version 8.
	Web Wiz Forums Hosting ASP.NET Web Hosting

jackals Members Profile Find Members Posts Groupie Joined: 27 June 2005 Location: United Kingdom Status: Offline Points: 66	Post Options Post Reply Quote jackals Report Post Thanks(0) Quote Reply Posted: 23 September 2006 at 7:59pm
	Can i use the Access version 7 to version 8 upgrade tool while the forum is still running with people making entry to the DB?

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 23 September 2006 at 9:36pm
	Sorry no, your forum needs to be completely disabled while the upgrade takes place and then after the database is upgraded it must ONLY be used with version 8
	Web Wiz Forums Hosting ASP.NET Web Hosting

jackals Members Profile Find Members Posts Groupie Joined: 27 June 2005 Location: United Kingdom Status: Offline Points: 66	Post Options Post Reply Quote jackals Report Post Thanks(0) Quote Reply Posted: 23 September 2006 at 10:08pm
	Cheers buddy

gregcaulder Members Profile Find Members Posts Newbie Joined: 20 March 2005 Location: United States Status: Offline Points: 19	Post Options Post Reply Quote gregcaulder Report Post Thanks(0) Quote Reply Posted: 13 February 2007 at 7:24pm
	What is the upgrade tool and were can I find it. Greg

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum