Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 341
  • Last Modified:

Citrix question

I can place the icon to launch MS access itself, but how can I have an icon for a specific database?  I do not want users to have to go through access to open it...I want it to open itself.  I tried just adding the DB as a published app, but it did not work.
0
mmreed
Asked:
mmreed
1 Solution
 
zmorvikCommented:
I have this running at numerous clients.

Create the published application with the following:

"<path to msaccess.exe>" "<path to mdb file>"

Example:
"D:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "\\servername\sharename\mydatabase.mdb"

If you have a workgroup information file (not required), it would go in between the above.  So, it would look something like:

"D:\Program Files\Microsoft Office\Office\MSACCESS.EXE" /wrkgrp "d:\database\system.mdw" "\\servername\sharename\mydatabase.mdb"

Instead of \\servername\sharename, you could use a local drive letter or a mapped drive letter.  I did this above just as an example.  In the case of a mapped drive letter, be very careful, because what I have seen happen is that the published application runs before the drives are mapped and you receive an error message.  This was such a problem for one client that I had to write a VB to create a delay and then launch the Access database.  Using a UNC (\\servername\sharename\mydatabase.mdb) should alleviate this problem if you aren't familiar with development languages.

Best Wishes.


0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now