Open Access 2016 With Batch File

[kdbailey]

We just upgraded to Office 2016. How do I use a batch file to run a macro in Access 2016? I used to run a batch file that reads the following... how do I adjust it?



C:
CD\Program Files (x86)\Microsoft Office 2007\Office12
MSACCESS.EXE "S:\Warranty Returns\WRA Data Storage\Warranty Returns - Back End.accdb" /x Overnight Chain
exit

[Gicu]

Have you tried to replace the path to the 2007 MSACCESS.EXE with the new one? Should be something like \Program Files (x86)\Microsoft Office\Office16
CD\Program Files (x86)\Microsoft Office 2007\Office12
MSACCESS.EXE "S:\Warranty Returns\WRA Data Storage\Warranty Returns - Back End.accdb" /x Overnight Chain

Cheers,
Vlad

[kdbailey]

That was my first thought, no success though. There is no MSACCESS.exe in the directory "C:\Program Files (x86)\Microsoft Office\Office16"

I took a look at my Access shortcut and it points at "C:\Program Files (x86)\Microsoft Office\root\Office16" however when I use that directory, it doesn't open anything.

[Gicu]

You must have the 64 bit version then; look in Program Files instead of Program Files (86).

Cheers,
Vlad

[kdbailey]

The only filepaths I have are...

C:\Program Files\Microsoft Office\Office15\
C:\Program Files\Microsoft Office 15\ClientX64\

Neither have a MSACCESS.exe file.

[Gicu]

Do you see a root subfolder?

https://answers.microsoft.com/en-us/...7e0-437e-9ef3-

Cheers,
Vlad

[kdbailey]

Negative, no root subfolder.

[June7]

Here is my VBScript code:

Set accessApp = CreateObject("Access.Application")
accessApp.OpenCurrentDataBase "C:\Users\June\LL\Umpires.accdb"
'accessApp.UserControl = True
accessApp.Run "Test" 'call VBA procedure
accessApp.DoCmd.RunMacro "TestMacro" 'call macro
accessApp.Quit

[Micron]

C:\Program Files (x86)\Microsoft Office\root\Office16
put that path into a file explorer window, click the navigation arrow and see if MSACCESS.EXE is there in the list of files. If it's not, you don't have it on the pc (at least in that location). You might be dealing with a run time file. If it's there, then your switch may be the problem (/x Overnight Chain).

[kdbailey]

Micron, that file is indeed there. However, when I use that folder nothing happens by running the batch file.

[kdbailey]

June7,

I adapted your code to my filepath and macro, however I'm getting the error...
"ActiveX component can't create object: 'Access.Application'"

Set accessApp = CreateObject("Access.Application")
accessApp.OpenCurrentDataBase "S:\Quality\PQG\Gary\Impromptu.accdb"
'accessApp.UserControl = True
'accessApp.Run "Test" 'call VBA procedure
accessApp.DoCmd.RunMacro "Update Chain" 'call macro
accessApp.Quit

[June7]

Sorry, don't get the error and since I can't replicate issue, have no idea how to correct.

[Gicu]

is the location of the db you are trying to open a trusted location?
Vlad

[kdbailey]

It is not, I just spoke with IT as the option to add a trusted location is grey'd out.

Is it a feature of the "Trusted Location" to not allow programmatic launch?

[Gicu]

I believe so, see this thread for more info:https://social.msdn.microsoft.com/Fo...orum=accessdev