Solved

Issue with MS-Access db application published on Citrix Server

Posted on 2009-03-31
6
370 Views
Last Modified: 2012-06-27
We have a CMS.mdb application file, that is published on a Citrix server.  The MS Access database has a Startup routine that hides the Database window and opens the MS Access form called frmSwitch.

If I have the CMS.mdb on my C: drive and double click it, it opens to frmSwitch and the Database window is hidden.  The button on the task bar on my laptop is titled 'CMS ' [frmSwitch : Form]'.  If I navigate to another form in the database the button on the task bar has the name of that other form.  If I minimize the MS Access window and then maximize it by clicking the button on my task bar, it comes back to the form I was on when I minimized.  This is the behavior we would expect.

If instead I use the .ica file to open the application on the Citrix server, I double click the .ica icon on my desktop, and after I log in to Citrix it opens to frmSwitch and the Database window is hidden.  This is the behavior we would expect.  The button on the task bar on  my laptop is titled 'CMS : Database - \\Remote'.  

Issue: If I minimize this .ica window and maximize it by clicking on the button on my task bar, it comes back to the CMS.mdb file but with the database window displayed.  This is not the expected behavior.

This is a major issue for us, because once the database window is available (unhidden) to the user, they can change data, forms, reports, queries, etc.

I'm wondering if there is something about the way Citrix or the ICA file is set up that is causing this behavior?
0
Comment
Question by:anandkswamy2008
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 11

Assisted Solution

by:pfcjoker
pfcjoker earned 200 total points
ID: 24033006
It's the way Citrix handles the seamless windows. There are some ways to change the default behavior using registry settings on the Citrix Server - http://support.citrix.com/article/ctx101644 covers this in detail.

In your case I think the two that may apply would be #2 and/or #19 - it will require a bit of testing on your part to figure out the right combo. I would set the registry for #2, reboot test, if it doesn't work try #19 alone, if that doesn't work I'd try both #2 and #19 added together (rebooting after every attempt).

Registry Key: HKEY_LOCAL_MACHINE/System/CurrentControlSet/Control/Citrix/wfshell/TWI
Value Name: SeamlessFlags
Value Type: REG_DWORD

example: #2 alone the value would be: 0x2
#19 alone: 0x200000
both: 0x200002
0
 

Author Comment

by:anandkswamy2008
ID: 24033329
Thank you for your help & suggestion. I'll test this and get back to you soon. Hopefully this should work
0
 

Accepted Solution

by:
anandkswamy2008 earned 0 total points
ID: 24035588
I just want to ask you one more favor, How would you convert Hex format value to Hexadecimal \ Decimal value.

When I created REG_DWORD type, I was not able to Add the value '0X2' for 2 or '0x200000' for 19.

Thank you in advance for offering prompt assistance in this regard, much appreciated.
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 11

Expert Comment

by:pfcjoker
ID: 24035843
when creating a reg dword you just input the number minus the 0x, it will handle the rest so when putting it in:

0x2 = 2
0x200000 = 200000
0x200002 = 200002

Note depending on your OS it may show up as 0x00200002 - that's OK - pretty sure that only happens in x64 OSes - but either way it should work as documented.
0
 

Author Comment

by:anandkswamy2008
ID: 24055885
Thanks for your solution. I tried all the above 3 options with rebooting after every attempt, but still it doesn't work. If I minimize this ICA window and maximize it by clicking on the button on my task bar, it comes back with the database window displayed. Thanks anyways I'll keep looking.

I had one more question, the button on the task bar on my laptop is titled 'CMS : Database - \\Remote'.  How can we change to say the Access application  <FrmName> on the button on my task bar?
0
 
LVL 11

Expert Comment

by:pfcjoker
ID: 24066345
I believe that is embedded in the client code - I don't see anything in the client options, registry, or ini files that points to a way to change it - nor is it covered in the Admin guide for the Citrix Clients, unless someone knows some undocumented way of doing it, I don't think it's possible.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Exchange server is not supported in any cloud-hosted platform (other than Azure with Azure Premium Storage).
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question