Running a macro from another database

Question

I have a database that I run TransferDatabase export from. I have a problem with the size of the 2nd database, so I delete all the tables in that one before running the transfer from the main one. 

Is there a way I can run the macro I have set up, to do the deletes in the 2nd database from the 1st before it starts to do the data transfers?

Answer 1

Why not use the function on that page?  Much simpler than starting from scratch, no?

If you want to use Shell, then follow the setup in the functions on that page.

Call Shell("msaccess.exe D:\Objects\ALE\ETO_46.accdb /x YourMacroName", 3)

Also, deleting the tables will not regain any space, you'll need to perform a compact prior to your import.

Answer 2

I tried running the code from the link but I keep getting an "Invalid procedure call or argument".

Here is how I have it written.

    Dim delTables

    delTables = Shell("D:\Objects\ALE\ETO_46.accdb", vbMaximizedFocus)

Answer 3

What about: http://www.devhut.net/2014/09/16/ms-access-run-a-macro-in-an-external-database/