[AccessD] Access crashing on Citrix

Hi Mark

In that case I would try moving these tables to a temporary file
recreated at each session for each user. It really isn't that
difficult - code or links to code have been published at the list
earlier.
I have used the technique once for an app that does a lot of
importing and validation and the combination of a write-protected app
and temporary datafiles which never bloat or get corrupted is great.

/gustav


> It does make temporary tables

> Mark Whittinghill
> Symphony Information Services
> 612-333-1311
> mwhittinghill at symphonyinfo.com
> ----- Original Message -----
> From: "Gustav Brock" <gustav at cactus.dk>
> To: <accessd at databaseadvisors.com>
> Sent: Wednesday, April 09, 2003 12:09 PM
> Subject: Re: [AccessD] Access crashing on Citrix


>> Hi Mark
>>
>> Have you tried write-protecting the application file or running it off
>> a directory where the users have read-only rights only?
>>
>> This, of course, requires that your app doesn't write to itself by,
>> say, creating temporary queries.
>>
>> /gustav
>>
>>
>> >   We have a client who is using an Access 2000 db on Citrix.  The Citrix
>> > environment is NT 4, Service pack 6A.  I don't understand all the
>> > specifics,
>> > but the hoster has two load balanced servers, I'll call A and B.  The
>> > last
>> > couple months, we have been seeing people unable to open Access, usually
>> > in the afternoon.
>>
>> > 1. All access apps are affected, not just ours.  A message will come up
>> > saying that the file can't be found.  Again, I don't know all the
>> > specifics,
>> > but the way the hoster installs Access it is like all users are sharing
>> > a copy of the Access program.  When one user's Access crashes,
>> > all do.  We haven't yet been able to determine the point of the failure.