Jim Dettman
jimdettman at verizon.net
Mon Feb 9 09:16:49 CST 2009
Dan, Actually, the global error handler may be more of an issue if it's using any kind of temp storage to do anything. That's what you need to watch out for; places where you assumed only one user would be in there at one time. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Monday, February 09, 2009 10:06 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Citrix and Access Hi Jim, Hi Mark, This is just the type of thing I was thinking I'd need to get resolved. I am working with my customer's IT guy who seems quite comfortable with Citrix, so that's good. I'll specifically ask him about mapping a unique path on the server to a drive letter for their terminal services profile. I agree with avoiding the sharing of references. My system now uses an AutoUpdater.mdb file that I wrote to ensure that each user automatically pulls the latest files from the server each time they open the application, so all references do go to files on the C drive. The FE.mdb, Library.mdb, TempTables.mdb, sound files, and one 3rd party dll file (VBA Global Error Handler from EverythingAccess.com), are checked for Last Modified Date and pulled to the client before the app is opened. There are continuous requests for modifications, so the FE.mdb and Library.mdb are updated frequently. This autoupdating is at least one scenario that we'll need to work through carefully. Another is that my app pulls a recordset from the mdw file on the server to see how many people are logged in. If they have 8 licenses, user 9 just gets a message that the app is 'full', and they are then logged out. Right now the max number of concurrent users is only 8, this may double or so in a couple of years. Thanks! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Sunday, February 08, 2009 4:34 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Citrix and Access Dan, Probably the biggest issue when running under Citrix is that the "C" drive is the same for everyone. That's a bit of a problem where you want everyone to have their own FE (which you would typically would install on their C drive). But there is an easy workaround for that; just map a unique path on the server to a drive letter for their terminal services profile (something like X) and place the FE there. A little more problematic however is references. If you open up an FE, you'll find all your references still pointing to C. For the most part, if your just using the typical references, this is not an issue. Those references can be shared with no problem. But if your using a library reference (a reference to a MDA) or some type of 3rd party component, then you might have issues with multiple users all sharing that reference. This is in fact the reason that some of the Wizards in Office are not available under TS; they simply won't work when shared. Unfortunately there is not easy work around for this. You have few choices. You can map the same drive letter for everyone (remote user or not) and write your app against that or you can distribute two different versions of the app (one that runs against C and one that runs against your mapped drive letter). I've been lucky enough to only run up against this once, but when you do it's a pain in the butt. Other then that, Access works wonderfully under TS/Citrix with JET or SQL Server. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Friday, February 06, 2009 4:05 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Citrix and Access Hi Arthur, Anything you can think of that might have been restrictive or need to know? I'll be switching out many users from running on their PC to using a Citrix window. Glad to hear about the response time! Was your FE linked to SQL 2000 or were you using an OLEDB Provider? Thanks, Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Friday, February 06, 2009 2:45 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Citrix and Access I have lots of experience running an Access app on Terminal Services, and even with 70 users it was faster for me to develop on the remote TS box than on my local machine at home. I was completely floored. Assuming a fast pipe on both ends, I think you will be very pleased with the response time. (To be fair, our Access back end was SQL 2000.) hth, Arthur -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com