The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.
Command line troubles
Hi,
When launching an access database from the command line, one of my user experience a weird behavior.
The database is supposed to recieve a command line like the following (value returned by the Command() function):
import="291" database="C:\Users\userNam
But he recieve:
import= 291 database= C:\Users\userName\My documents\Application_DATA
Quotes are stripped, and an additional space is inserted right after the "=" sign (or quotes are replaced by a space).
Do you see anyhing that can explain this behavior ?
When launching an access database from the command line, one of my user experience a weird behavior.
The database is supposed to recieve a command line like the following (value returned by the Command() function):
import="291" database="C:\Users\userNam
But he recieve:
import= 291 database= C:\Users\userName\My documents\Application_DATA
Quotes are stripped, and an additional space is inserted right after the "=" sign (or quotes are replaced by a space).
Do you see anyhing that can explain this behavior ?
Who is Participating?
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
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.
The command line comes from a batch:
"C:\Program Files (x86)\Microsoft Office\Root\Office16\msaccess.exe" "C:\Users\userName\My documents\Application_PRG.accdb" /cmd import="291" database="C:\Users\userName\My documents\Application_DATA.accdb"
Quotes in command line means it is text part and it will be delivered without quotes.
I don't believe it is working anywhere.
Try
/cmd "import=291" "database=C:\Users\userNam
from command you should get two parameters:
import=291
and
database=C:\Users\userName
I don't believe it is working anywhere.
Try
/cmd "import=291" "database=C:\Users\userNam
from command you should get two parameters:
import=291
and
database=C:\Users\userName
@als315: Afraid not. As I stated, I recieve the command line as expected, but one user don't.
From my knowledge, Access is supposed to forward the whole string following the /cmd argument untouched.
And the Command() function return a string, not a container.
From my knowledge, Access is supposed to forward the whole string following the /cmd argument untouched.
And the Command() function return a string, not a container.
I can't test your command now, will do it later today, but Access can get more then one parameter, divided by space, like this:
/cmd "Parm1" "Parm2"
You can try:
/cmd "import=""291""" "database=""C:\Users\userN
/cmd "Parm1" "Parm2"
You can try:
/cmd "import=""291""" "database=""C:\Users\userN
May be this is correct:
/cmd "import=""291"" database=""C:\Users\userNa
/cmd "import=""291"" database=""C:\Users\userNa
The issue is:
Why on one computer the command line is forwarded intact, and why on the 2nd computer it is not.
Notes:
Applications recieve command line as string, quotes are here to handle spaces. It is up to their parsing functionality to tanstype values or do whatever they want with it.
Why on one computer the command line is forwarded intact, and why on the 2nd computer it is not.
Notes:
Quotes in command line means it is text part and it will be delivered without quotes.This is false.
Applications recieve command line as string, quotes are here to handle spaces. It is up to their parsing functionality to tanstype values or do whatever they want with it.
Anything different about the machine? Like a different language, etc?
Can you try logging into that machine as a different user and see if the same behavior exists? If it does not, then try logging in as the "trouble" user on a different machine - does the behavior follow the user?
I ask because I had a similar experience many years ago with an Access database and the Command function, and traced it down to a bad user profile. I'm not sure how the user profile has anything to do with that, but once I created a new user profile, the issue went away.
Can you try logging into that machine as a different user and see if the same behavior exists? If it does not, then try logging in as the "trouble" user on a different machine - does the behavior follow the user?
I ask because I had a similar experience many years ago with an Access database and the Command function, and traced it down to a bad user profile. I'm not sure how the user profile has anything to do with that, but once I created a new user profile, the issue went away.
Sorry, Fabrice, I was wrong, you were correct. New knowledge, thanks. Never see before that you can't send 2 parameters one by one:
/cmd "Param1" "Param2"
but
/cmd i="Param1" j="Param2"
is possible.
Looks like there is some undocumented interpreter.
/cmd "Param1" "Param2"
but
/cmd i="Param1" j="Param2"
is possible.
Looks like there is some undocumented interpreter.
Well, no luck with logging on his computer.
No explanations still, I suspect something on computer's environent (go figure what with limited privilèges).
Doubling double quotes fixed the issue, even tho, I do not like it because we have an heterogenous command line.
No explanations still, I suspect something on computer's environent (go figure what with limited privilèges).
Doubling double quotes fixed the issue, even tho, I do not like it because we have an heterogenous command line.
I'd agree with the environment issue, and with things like this you'll have a hard time sussing it out.
An Office repair or reinstall may resolve the issue, but that would be a last-ditch effort.
An Office repair or reinstall may resolve the issue, but that would be a last-ditch effort.
An Office repair or reinstall may resolve the issue, but that would be a last-ditch effort.Alas, not my responsibility.
Thanks for the input tho.
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 trialIt'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
Microsoft Access
From novice to tech pro — start learning today.
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.