Solved

Issue with MS-Access db application published on Citrix Server

Posted on 2009-03-31
6
366 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
  • 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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Citrix XenApp, Internet Explorer 11 set to Enterprise Mode and using central hosted sites.xml file.
Citrix XenDesktop 7.6 Citrix Policies Audio
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

705 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now