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
Solved

Issue with MS-Access db application published on Citrix Server

Posted on 2009-03-31
6
369 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

If your vDisk VHD file gets deleted from the image store accidentally or on purpose, you won't be able to remove the vDisk from the PVS console. There is a known workaround that is solid.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
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…

839 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