No go. It bawled about my lotus dll and immediately went in to the freeze mode.
Respectfully,
Liz Ravenwood
Software Engineer
Interior Systems
(520) 239-4808
Liz_ravenwood@beaerospace.com
rockwellcollins.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, May 03, 2017 1:05 PM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: RE: [MS_AccessPros] timer event with citrix timeout issue
Crystal!
Good to hear from you and I hope all is well.
I'm not optimistic this would work because of licensing requirements and we'd have to have a local copy. Then, I know what when I run my local copy only for decompiling only, it is freakishly slow. I also use an email library to send email (lotus).
But... I think I'll try it anyway just to check it out.
While I'm on the subject, there have been a couple of times that pulling up a dev copy of my database outside of citrix, it would freeze and lose all my vba. Have you heard of that happening?
Respectfully,
Liz Ravenwood
Software Engineer
Interior Systems
(520) 239-4808
Liz_ravenwood@beaerospace.com
rockwellcollins.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, May 03, 2017 12:04 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] timer event with citrix timeout issue
Hi Liz,
Would Windows Task Scheduler work instead? Access Timer events can have other problems too, especially after a few days ... and if you do use Access anyway, perhaps lengthen the time interval. You can probably run an update query or something -- be much better than using SendKeys
respectfully,
crystal
http://www.MsAccessGurus.com
connect to me, let's build it together
~ have an awesome day ~
On 5/3/2017 10:25 AM, Liz Ravenwood liz_ravenwood [MS_Access_Professionals] wrote:
> Pros, I have a database that runs on a timer and is supposed to run every 6 hours. It has to run within Citrix. Citrix has a timeout of 3 hours of inactive keyboard input to go to disconnect, and then another 2 hours to log out. My timer event is set on a one minute interval but only runs the report at 3 and 9 AM and PM.
> This all works beautifully as long as I am logged in and keeping my session active.
>
> So, I coded a SendKeys("{ENTER}") to happen at the one minute interval hoping that this would keep the session active, but it did not.
>
> Suggestions? Ideas? Thanks.
>
> Respectfully,
> [RCEmailSigLogo]
> Liz Ravenwood
------------------------------------
------------------------------------
------------------------------------
Yahoo Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
------------------------------------
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
------------------------------------
------------------------------------
Yahoo Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar