The only "catch" is that if the access data store goes down the LHC (Local Host Cache) will not always keep the Farm information for 24 hours. With the SQL data store it works better. This is a confirmed problem with Access and Citrix. I will repeat what earlier post stated "Do not put SQL on a current Citrix server". Steve Oberg -----Original Message----- From: SPerez@xxxxxxxxxxxxxxx [mailto:SPerez@xxxxxxxxxxxxxxx] Sent: Monday, February 24, 2003 8:07 AM To: thin@xxxxxxxxxxxxx Subject: [THIN] Re: SQL Server or Access? Matt, In my real world experience I would recommend using Access as your data store if you have less then 7 XP servers. Anything over 7 servers use SQL as the datastore. Do not put SQL on a current Citrix server. Also if you happen to have the servers set a server with little load to be the master browser. Good Luck, ____________________________ Steve Perez "Shaw, Matthew" <Matt.Shaw@xwav To: "'thin@xxxxxxxxxxxxx'" <thin@xxxxxxxxxxxxx> e.com> cc: Sent by: Subject: [THIN] SQL Server or Access? thin-bounce@fre elists.org 02/24/2003 09:29 AM Please respond to thin Hello all, Could someone give me an idea of in what situation I should use a standalone SQL server and what situation I should use an Access database for XP stuff? Also, what are the benefits/impacts of using each? I've read some documentation, but I'd like to get a 'real world' answer. Thanks Matt Shaw ---------------------------------------------------------------------------- This communication (including all attachments) is intended solely for the use of the person or persons to whom it is addressed and should be treated as a confidential xwave communication. If you are not the intended recipient, any use, distribution, printing, or copying of this email is strictly prohibited. If you received this email in error, please immediately delete it from your system and notify the originator. Your cooperation is appreciated. ********************************************************* This Week's Sponsor - Neoware Now through March 31, 2003 Neoware is offering a Capio 500/Eon Proven 2100 for $299! Click the link below: http://www.neoware.com/promocp4a/thinnetban.html ********************************************************** For Archives, to Unsubscribe, Subscribe or set Digest or Vacation mode use the below link: http://thethin.net/citrixlist.cfm ********************************************************* This Week's Sponsor - Neoware Now through March 31, 2003 Neoware is offering a Capio 500/Eon Proven 2100 for $299! Click the link below: http://www.neoware.com/promocp4a/thinnetban.html ********************************************************** For Archives, to Unsubscribe, Subscribe or set Digest or Vacation mode use the below link: http://thethin.net/citrixlist.cfm ********************************************************* This Week's Sponsor - Neoware Now through March 31, 2003 Neoware is offering a Capio 500/Eon Proven 2100 for $299! Click the link below: http://www.neoware.com/promocp4a/thinnetban.html ********************************************************** For Archives, to Unsubscribe, Subscribe or set Digest or Vacation mode use the below link: http://thethin.net/citrixlist.cfm