Re: Citrix occasionally corrupting row of data.

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]" <ttoews@xxxxxxxxxxxxxxx> wrote in message
news:pga883llru07aqhfug842v8rk04er11mq9@xxxxxxxxxx
"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: Citrix occasionally corrupting row of data.
    ... the idea of logging and tracking stuff is probably the way to go. ... That screen shot is ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ...
    (comp.databases.ms-access)
  • Re: Convert foxpro to access
    ... For the forms and reports, I made screen shots of each ... I was looking for a way to convert a foxpro database to an access ... box for the community table which is one of the tables in the ... I'd be glad to send a screen shot to anyone who requires it to assist ...
    (microsoft.public.access.queries)
  • Re: [PHP] Re: Screen Shots
    ... > Is there any way that I can get a script to take a screen shot every minute ... and the user's login information if that's available. ... the result into a tracking table in your database. ... There's no need to do a screen capture. ...
    (php.general)
  • Re: [PHP] Re: Screen Shots
    ... the result into a tracking table in your database. ... selected by time period. ... There's no need to do a screen capture. ... Why do you need a screen shot when you can get a history page any time you want to? ...
    (php.general)
  • Screen shots
    ... How and what is the best way I can store a MS Word or maybe and Outlook ... screen shot into my database. ...
    (microsoft.public.access.formscoding)