[THIN] Re: Access 97 running on W2K TS - MF FR2

  • From: "Alexander Danilychev" <teknica@xxxxxxxxxxx>
  • To: thin@xxxxxxxxxxxxx
  • Date: Thu, 06 Mar 2003 00:29:33 -0800

Default thread count for Access 97 is 3 (can be changed), database size is 
limited to 1 GB - here is your ultimate limitation.

The only way to increase user count is to use middle tier or a web server, 
i.e. using "in and out" approach. Careful design is required when supporting 
above 20-25 people.

Go with SQL server if you can -- do not waste time unless you have no 
control of your app. Defragment ("compact") your database often. Possibly 
split data into several databases, keep interface (if you use Access as 
interface) in a separate database, etc.

Win2K and MetaFrame FR2 do not make any difference versus older platform.


>From: "Tom Flanagan" <Tom.flanagan@xxxxxxxxxxxxxxxxxxxx>
>Reply-To: thin@xxxxxxxxxxxxx
>To: "'Thin (E-mail)" <thin@xxxxxxxxxxxxx>
>Subject: [THIN] Access 97 running on W2K TS - MF FR2
>Date: Thu, 6 Mar 2003 15:35:46 +0800
>Is anybody running Access97 apps on this platform.  W2K TS - Citrix MF FR2. 
>   We rebuilt our systems from NT4.0 TSE to W2K sp3.  Clean rebuilds. We 
>run about 5 different access 97 databases.  The DBs were developed in-house 
>using unconventional database design techniques.  There could be 20 users 
>running Access at any one time on a server and this would grind to a halt.  
>   Hardware on the servers is (Dual Pentium 1Ghz) [2GB ram] {4gig pagefile} 
>on seperate disc. Plenty of diskspace
>In the end I have reverted back to the NT4.0 build.
>Is this an access 97 / W2K thing. I have found some comments that suggest 
>Microsoft know about this problem but are just ignoring it. Is anybody 
>running this app effectively or have any of you had performance issues 
>Tom Flanagan
>IT Network Administrator
>Kailis & France Foods
>Ph: +61 8 9273 6281
>Mob: 0408 927 247
>email: tom.flanagan@xxxxxxxxxxxxxxxxxxxx
>This Week's Sponsor - ThinPrint
>Simply the best print solution for Citrix
>Metaframe and Microsoft Terminal Services!
>For Archives, to Unsubscribe, Subscribe or
>set Digest or Vacation mode use the below link:

MSN 8 with e-mail virus protection service: 2 months FREE*  

This Week's Sponsor - ThinPrint
Simply the best print solution for Citrix
Metaframe and Microsoft Terminal Services!

For Archives, to Unsubscribe, Subscribe or 
set Digest or Vacation mode use the below link:

Other related posts: