DosTips.com

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:



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



but as soon as i try it like that:



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

Try this

or


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


Regards
aGerman

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

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

ok well talking already about understanding... so what does themean?
"Look in the same folder" or something similar?

Greetings my friend

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

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