Citrix occasionally corrupting row of data.

[dlesandrini]

I've googled this one high and low, but can't find a similar hit.
Looking for ideas from someone with Citrix experience.

Client opens employee record with Address subform embedded.
The screen shot they sent me shows the data corrupted as follows,
with an diminished copy of the text tacked onto the end. Imagine
the following, but without the spaces, which I added for clarity.

City: Madisonville adisonville disonvi
State: KYY
Zip: 42431 2431 431 31 1

You can view the actual screen shot here ...
http://www.amazecreations.com/datafast/Citrix_Issue.jpg

Has anybody ever seen anything like this, on Citrix or not?

Danny J. Lesandrini
dlesa...@hotmail.com

[Tony Toews [MVP]]

"dlesandrini" <data...@comcast.net> wrote:

>Client opens employee record with Address subform embedded.
>The screen shot they sent me shows the data corrupted as follows,
>with an diminished copy of the text tacked onto the end. Imagine
>the following, but without the spaces, which I added for clarity.
>
>City: Madisonville adisonville disonvi
>State: KYY
>Zip: 42431 2431 431 31 1
>
>You can view the actual screen shot here ...
> http://www.amazecreations.com/datafast/Citrix_Issue.jpg

Very interesting. Thanks for the screen shot. Is there any interesting code behind
the forms? I suspect not but I thought I'd ask.

>Has anybody ever seen anything like this, on Citrix or not?

I'm wondering if there are multiple servers in this Citrix system and if they all
have the same version of Jet.

What I've done is use the various API calls available and am checking the version
number and date/time of a crucial dll, msjetxx.dll, to ensure it matches what I have
on my system. See the Verify Appropriate Jet Service Pack is installed page at my
website for more details including sample code:
www.granite.ab.ca\access\verifyjetsp.htm

Also we were getting corruptions with one of the four Citrix load balanced servers so
the cilent put my app on just one of the other servers. It worked quite well after
that.

To track when people logged in and out as well as abnormal terminations I did the
following.

In one situation I created some logic behind a hidden form which was opened when the
database was opened. It added a record to a logging table containing relevant info
such as NT userid, work station name and so on. The autonumber ID of this record was
retained on the form. When the database was closed, which meant this form was
closed, the form then updated that record, using the stored autonumber ID as having
normally terminated.

We could then monitor users who were having problems or were using abnormal methods
of closing Access. Kinda funny to visit a user and state "I see you were having a
problem yesterday. What was happening?" They'd look a bit surprised and then tell
you. We never had to worry about someone doing the Ctrl+Alt+Del or hitting the power
switch as it was an all NT4 network and they were good users.

I get my information which I log from the workstation name and the NT logon user
name. See the API calls at the Access Web at www.mvps.org/access. I haven't
bothered to use Access security yet.

This comes in quite useful in tracking corruptions. The station which terminated
abnormally leaves their record in this table not flagged as closing. Everyone else
can exit normally so their record is flagged as having exited normally. Of course
when you have a power failure everyone's record in the database gets left "open".

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[dlesandrini]

Thanks Tony

A lot of great ideas. This client is offsite, and one I've never visited,
but
the idea of logging and tracking stuff is probably the way to go. I was
hoping that someone had experienced it. That screen shot is distinctive
and if it had happened to anyone, they would probably have recognized it.

Thanks again for your comprehensive suggestions.
Danny

"Tony Toews [MVP]" <tto...@telusplanet.net> wrote in message
news:pga883llru07aqhfu...@4ax.com...

[David W. Fenton]

"dlesandrini" <data...@comcast.net> wrote in
news:TfudnUmdoKsdqhnb...@comcast.com:

> A lot of great ideas. This client is offsite, and one I've never
> visited, but
> the idea of logging and tracking stuff is probably the way to go.
> I was hoping that someone had experienced it. That screen shot is
> distinctive and if it had happened to anyone, they would probably
> have recognized it.

It looks to me like some kind of keyboard driver problem, so
mismatch between what is sent and what is received.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[Tom van Stiphout]

On Thu, 28 Jun 2007 08:30:00 -0600, "dlesandrini"
<data...@comcast.net> wrote:

Sorry I can't be any help. Wow, without a screenshot I would never
have believed this.
In general Citrix can be a quite challenging environment. I'm dealing
with a client right now who is having to make major adjustments to his
Delphi application before he can run under Citrix. Then there is
another client who is running a VB6 to SQL Server app and the VB app
is poorly written, but it works all the time no complaints.
I wonder if as a test you could upsize a few tables to SQL Server and
see if the problem persists.

-Tom.

[Tony Toews [MVP]]

"David W. Fenton" <XXXu...@dfenton.com.invalid> wrote:

>> I was hoping that someone had experienced it. That screen shot is
>> distinctive and if it had happened to anyone, they would probably
>> have recognized it.
>
>It looks to me like some kind of keyboard driver problem, so
>mismatch between what is sent and what is received.

To me it looks like somehow Jet misread data by a number of character and then
updated the page. As we all know we can have variable length data in text fields in
tables. Thus somehow Jet thought that a particular field was a number of bytes
shorter (or longer) than it really was.

Hmm, I wonder if a field was inserted into the middle of that table and the caching
of the metadata in the linked tables wasn't updated. The infarmous -1517 error in
Jet 3.5. http://www.granite.ab.ca/access/reservederror1517.htm

[Tony Toews [MVP]]

Tom van Stiphout <no.spam...@cox.net> wrote:

>In general Citrix can be a quite challenging environment.

Whereas in Access it was quite painless. I had to setup a one line .cmd file to
call the Auto FE Updater and that was it. Of course we still had to give each user
their own FE.

[paii, Ron]

"dlesandrini" <data...@comcast.net> wrote in message
news:ib6dnb-IpeljWB7b...@comcast.com...

I have been running Access97 on Citrix since 1999 on NT4 and 2000, and have
never seen this problem. But by any chance are your users sharing a common
front end on the Citrix box?

[dlesandrini]

I'd like to thank everyone for their comments. I tend to agree with Tony.
The keyboard
idea is reasonable, but remember that several text boxes are affected. The
user would
have had to not notice what was happening. In fact, it is reported that
records which
haven't been accessed in years come up like this. Sounds like Jet to me as
well.

Danny

"Tony Toews [MVP]" <tto...@telusplanet.net> wrote in message

news:umr883ton3i4bn9b8...@4ax.com...

[yanto]

Need to check in the backend site, if those fields do realy contain
the corrupted data or just shown in the citrix connected frontend
site?
HTH
Yanto

[CDMAP...@fortunejames.com]

That's good advice. If the problem is limited to certain frontends,
maybe the video driver is at fault. It doesn't hurt to get the latest
video driver available.

James A. Fortune
CDMAP...@FortuneJames.com

[dlesandrini]

That is genius! Thanks for the lead.

Danny

<CDMAP...@FortuneJames.com> wrote in message
news:1183316591....@k79g2000hse.googlegroups.com...