Re: Citrix occasionally corrupting row of data.

"dlesandrini" <datafast@xxxxxxxxxxx> 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/
.

Relevant Pages

  • Re: Database Corruption
    ... I specifically created the Auto FE Updater utility so that I could ... For more info on the errors or the Auto FE ... that would cause the corruptions. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.formscoding)
  • Re: Network Shortcut Problems
    ... corruptions though. ... I think it's more a matter of the network component OS keeps retrying ... And Access times out pretty ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.security)