Web Wiz Support and Community Forums : Access Question?? https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 12:53:54 +0000 Thu, 17 Mar 2005 16:21:03 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=14285 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Access Question?? : Ahhhh I see.... Might just...]]> https://forums.webwiz.net/access-question_topic14285_post79098.html#79098 Author: NISSANGTIR
Subject: 14285
Posted: 17 March 2005 at 4:21pm

Ahhhh I see.... Wink
 
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???
]]> Thu, 17 Mar 2005 16:21:03 +0000 https://forums.webwiz.net/access-question_topic14285_post79098.html#79098 <![CDATA[Access Question?? : you can keep the current set up...]]> https://forums.webwiz.net/access-question_topic14285_post79096.html#79096 Author: dj air
Subject: 14285
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 thewhole database has to be loaded into memory, where as SQL itr loads thesection it needs, as Access is a flat file.
]]> Thu, 17 Mar 2005 15:59:06 +0000 https://forums.webwiz.net/access-question_topic14285_post79096.html#79096 <![CDATA[Access Question?? : Hmmmmmmmm thats strange.... Micro$oft...]]> https://forums.webwiz.net/access-question_topic14285_post79093.html#79093 Author: NISSANGTIR
Subject: 14285
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 Wink
 
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 Confused - Have made sure I keep compacting and repairing the DB
]]> Thu, 17 Mar 2005 15:08:03 +0000 https://forums.webwiz.net/access-question_topic14285_post79093.html#79093 <![CDATA[Access Question?? : there isn&#039;t any real difference...]]> https://forums.webwiz.net/access-question_topic14285_post79090.html#79090 Author: dj air
Subject: 14285
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.
]]> Thu, 17 Mar 2005 14:42:16 +0000 https://forums.webwiz.net/access-question_topic14285_post79090.html#79090 <![CDATA[Access Question?? : Ok I have updated my access database...]]> https://forums.webwiz.net/access-question_topic14285_post79088.html#79088 Author: NISSANGTIR
Subject: 14285
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?? Confused
]]> Thu, 17 Mar 2005 14:39:28 +0000 https://forums.webwiz.net/access-question_topic14285_post79088.html#79088