Access DB and Archiving

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
bruce Members Profile Find Members Posts Groupie Joined: 16 April 2003 Location: United States Status: Offline Points: 102	Post Options Post Reply Quote bruce Report Post Thanks(0) Quote Reply Topic: Access DB and Archiving Posted: 12 November 2003 at 7:50am
	About how big can an access DB get before you will begin to see problems with the forum? Right now my access db is around 45 mb and it seems to be ok, however it does seem to be getting a little slower. Is it difficult to convert an access db to MS SQL? Is there anyway to archive posts. I'd like to archive each years posts, i.e. 2003, 2004 etc. and if so will it improve the forum performance?

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: 12 November 2003 at 8:18am
	The size an Access database can be depends on the server. Processing power, memory, how many other sites and servers loads all play parts in this. Access has an upsize wizard to upsize the database to MS SQL server.
	Web Wiz Forums Hosting ASP.NET Web Hosting

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.