Access Question??
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=14285
Printed Date: 12 April 2026 at 3:54pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Access Question??
Posted By: NISSANGTIR
Subject: Access Question??
Date 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??
 |
Replies:
Posted By: dj air
Date 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. |
Posted By: NISSANGTIR
Date 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 |
Posted By: dj air
Date 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. |
Posted By: NISSANGTIR
Date 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???
|