Access Question??

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
NISSANGTIR Members Profile Find Members Posts Groupie Joined: 20 April 2004 Location: United Kingdom Status: Offline Points: 85	Post Options Post Reply Quote NISSANGTIR Report Post Thanks(0) Quote Reply Topic: Access Question?? Posted: 17 March 2005 at 2:39pm
	Ok I have updated my access database to 2003 so it can take more users at one time and is (So Micro$oft say) much quicker?? Still ... At what point should I consider a switch to SQL??? As its now the latest access DB will I need to at all??

dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply Posted: 17 March 2005 at 2:42pm
	there isn't any real difference between 2002 and 2003 versions of Access. looking at your states and trhe number of forums spacificlly i would recommend upgrading now. this will be easier with it being smller but also your site will benefit from it as it is now.

NISSANGTIR Members Profile Find Members Posts Groupie Joined: 20 April 2004 Location: United Kingdom Status: Offline Points: 85	Post Options Post Reply Quote NISSANGTIR Report Post Thanks(0) Quote Reply Posted: 17 March 2005 at 3:08pm
	Hmmmmmmmm thats strange.... Micro$oft have said that the latest Access DB's are supposed to be able to handle loads more concurrent users?? Thats why I updated it..... I'll see if I can dig the article out Thanks for the advice... Not sure whether to wait for version 8 and then go to SQL?? Everything seems super fast at the moment though - Have made sure I keep compacting and repairing the DB

dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply Posted: 17 March 2005 at 3:59pm
	you can keep the current set up and wait till V8 if you want. but in the future before the V8 release it maybe worth doing so ..depending the size etc. the main reason to avoid Access is every time the database is used the whole database has to be loaded into memory, where as SQL itr loads the section it needs, as Access is a flat file.

NISSANGTIR Members Profile Find Members Posts Groupie Joined: 20 April 2004 Location: United Kingdom Status: Offline Points: 85	Post Options Post Reply Quote NISSANGTIR Report Post Thanks(0) Quote Reply Posted: 17 March 2005 at 4:21pm
	Ahhhh I see.... Might just have a go at upgrading soon you know... I did see a tutorial on how to transfer from one to the other didn;t I???

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.