Batch file doesn't process parameter

[avalancha]

Hey out there!

I have a quiestion concerning a .bat of mine and I hope this is the right spot to post it:

My task is the following: I need to write a batch that starts an Access database and processes a parameter to it so that a module I created can catch it as the following:

Code: Select all

If Command = "test" Then

But the batch has to work with relative paths and that's where the problems come in: it all works fine like this:

Code: Select all

"C:\Program Files\Microsoft Office\Office11\Msaccess.exe" "C:\Program Files\Subdirectory\business.mdb" /cmd "orders"

but as soon as i try it like that:

Code: Select all

".\business.mdb" /cmd "orders"

the database opens up (it's always in the same folder) but the parameter is not processed and the module does not work!

I really need help here, thanks in advance!!

Best regards,
Patrick

[aGerman]

Try this

Code: Select all

start "" "msaccess.exe" "%~dp0business.mdb" /cmd "orders"

or

Code: Select all

start "" "msaccess.exe" "%cd%\business.mdb" /cmd "orders"

The option /wait means that your batch will not continue until you close Access.

Code: Select all

start "" /wait "msaccess.exe" "%cd%\business.mdb" /cmd "orders"

Regards
aGerman

[avalancha]

yea I knew "/wait" before but hey:
oh... my... god
you are the BEST!!!! It works!!

Du kannst dir nicht vorstellen was für einen Gefallen du mir grade getan hast und wie viele Tage Rumgemurkse damit zu Ende gehen! DANKE!

Best regards,
Patrick

[aGerman]

You're welcome.
For your understanding:
The dot (.\) is only relative to your batch file, but not to msaccess.exe. It needs the entire path.
Because /cmd is a switch of msaccess.exe you can't use it only with the .mdb file.

Grüße aus Thüringen nach Baden-Württemberg

[avalancha]

ok well talking already about understanding... so what does the

Code: Select all

%~dp0

mean?
"Look in the same folder" or something similar?

Greetings my friend

[aGerman]

Well, I'm sure that you know parameters like %1, %2 etc.
%0 is a special kind of parameter and contains the "own call" of the batch file (means something like the full name). You can use options for this parameters, so the d is for drive and the p is for path. All in all %~dp0 returns drive and path of your batch file. For all those options have a look to the help of call (call /?).
%cd% is similar, but not the same. It contains the current working directory of your batch file, but this can be changed using CD or PUSHD / POPD commands.

Hope this will clarify some more, my friend

[avalancha]

Jep, sure did.
You know, I'm rather a C programmer and quite new to this stuff... I had never heard about this parameter before, therefore again: tanks

Patrick