Citrix Streaming Publishing: Extra Command Line Parameters - Can not handle filename with spaces.

I am using Citrix XenApp 4.5 and I am streaming application from the server.  I am publishing a MS Access database.  Therefore, I am pointing my profile to Office.prof.
The Application to Launch is soecified as Microsoft Access 2003.
The Extra Command Line Parameter - points to the UNC path of the database, but the database filename has a space in it:
"\\server1\test\database rules test.mdb" %**

When this profile is streamed, I get an error in MS Access and the filename is truncated on the space - therefore, it shows:

Can not open - "\\server1\test\database.mdb"

I have seen writeups about this on the Citrix Forum, however,  there are no solutions for Streaming from the Server.
rmessing171ConsultantAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Daniel BorgerSenior Citrix Engineer- CCEECommented:
can you shorten the database name and get it to work?
0
rmessing171ConsultantAuthor Commented:
I can not try that right now, the client does not want to shorten the name, as well as, they do not want to replace the spaces with underscores.
0
Daniel BorgerSenior Citrix Engineer- CCEECommented:
What about using 8.3 naming convention?

http://support.citrix.com/article/ctx785732
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

rmessing171ConsultantAuthor Commented:
The client will not change the name of the database.  I had seen the citrix article you referenced and the solution does not work for streaming from the server.  It only works for Streaming from the Client.
0
Daniel BorgerSenior Citrix Engineer- CCEECommented:
sorry, I meant try using the Extra Command Line Parameter path as 8.3
0
rmessing171ConsultantAuthor Commented:
can you take my example of "\\server1\test\database rules test.mdb" and show me how you make it 8.3?
0
Daniel BorgerSenior Citrix Engineer- CCEECommented:
\\server1\test\databa~1.mdb  

Could you copy the database local to the server and try that path?

If that does not work perhaps you could try having the Extra Command Line Parameter go to a batch file that opens the database.

0
rmessing171ConsultantAuthor Commented:
dborger,

I think you are getting close for me.  I have not tried the 8.3 naming convention, but will try it when I get a moment.

Per the batch file called in the Extra Command Line Parameter, how would I specifiy to call the batch file in the Extra Command line parameter, so:

I am telling it to execute msaccess.exe as the target, but how would the EXtra Command Line Parameter look to call the batch, I just can not say:

Target: C:\msaccess.exe

Extra Command Line: M:\database.bat

Do I need a pipe (|) to the information?
Please let me know when you get a quick moment.

Thank you for your awesome assistance!
0
Daniel BorgerSenior Citrix Engineer- CCEECommented:
the batch file would be something like this.
start C:\folder\database rules test.mdb
0
rmessing171ConsultantAuthor Commented:
Thanks!  So just to recap, if I was to run it from a command line or run without the batch file:

c:\msaccess.exe start c:\folder\database rules test.mdb

0
rmessing171ConsultantAuthor Commented:
The 8.3 naming convention worked.  I tried using a BAT file in the Extra Command Line Paramters and it did not work.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Citrix

From novice to tech pro — start learning today.