Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to publish Access database via citrix? 1

Status
Not open for further replies.

zacca

Technical User
Dec 25, 2003
333
HK
Hi there,

When I remote control citrix server, launched ms access from there, open a database on another server \\svr1\share\test1.mdb, it works without problem.

Then I shared this mdb via citrix by using \\svr1\share\test1.mdb as the program path, it didn't work.

What's the correct way to launch access & open that test1.mdb file immediately?

Many thanks!
 
I would say that you would have to publish Access with a switch to the DB that you wish to open, like this:

C:\Program Files\Microsoft Office\Office\MSACCESS.EXE X:\share\test1.mdb

This is of course if you map the svr1 to the X:\ drive.

I have never tried to launch an application like this using the UNC path. The one database that we publish, needs special rights, so we do it through a .bat file.

@echo off
if exist g:\data\ncis\nul goto skipmap
net use g: \\10.x.x.x\pvol03
:skipmap
nciswrsc.lnk

The .lnk file calls:

"K:\Program Files\Microsoft Office\ART\Office\MSACCESS.EXE" /user normal /wrkgrp g:\data\database.mdw G:\Data\database.mde

Hope this helps and doesn't cause any more confusion!!!

Mike Brown
 
Hi Mike,

Thanks for your tips, now it works as follow syntax:
"c:\path\msaccess.exe" "\\uncpath\file.mdb"

It won't work without the " " quote.

A star for your super help!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top