Backup

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
kegan5 Members Profile Find Members Posts Newbie Joined: 22 March 2006 Status: Offline Points: 6	Post Options Post Reply Quote kegan5 Report Post Thanks(0) Quote Reply Topic: Backup Posted: 24 April 2006 at 12:53pm
	Large Access Database needs backing up. Last time this was done a number of errors suddenly appeared which stopped login being available for a while, as well as it saying the location of the database was wrong...which it wasnt because nothing was changed or moved. Is there an ideal way to do an access database backup?

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: 24 April 2006 at 5:20pm
	My only advice is DON'T use Access for large forums!!! Access is a flat office file and storing a forum in an Access database is like storing the forums data in a large text file, and as you can imagine with lots and reads and writes going on this giant text file often becomes corrupted. I would only recommend using Access as a database backend for a forum if you are only expecting a handful of users only posting a very limited number of posts and you have no other choice. What you really need is a real Database Management System like mySQL or SQL Server as the backend for the forum. I would prefer to drop the Access version altogether of web wiz forums, but the only reason I kept it on is as an introduction to forums for novice users, but if you get serious about running a forum then you NEED to look at using mySQL or SQL Server as the backend.
	Web Wiz Forums Hosting ASP.NET Web Hosting

dpyers Members Profile Find Members Posts Senior Member Joined: 12 May 2003 Status: Offline Points: 3937	Post Options Post Reply Quote dpyers Report Post Thanks(0) Quote Reply Posted: 26 April 2006 at 12:15am
	lock the forum before you do a backup.
	Lead me not into temptation... I know the short cut, follow me.

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

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.