BAT file does not work if Access is already open (1 Viewer)

[illusionek]

Hello!

I use below simple command line to start a macro in my Access database. Usually all works well. I start my bat file, command is executed and macro does its job.

However it always fails if I have a session of Access already opened even if it is a completely different database. If I use below then it opens another sessions of Access but does not execute the macro. I need to go into the second session and run macro manually. It works fine then.

Any ideas why and how to fix it?

Many thanks.

"C:\Users\Me\Documents\Databas1.accdb" /X Macro

 

[boerbende]

Starting your application with a specific form (maybe you do this already) which runs the macro in the onload event.