Start up MS-Access with /x option and run a macro in a different access db

[hxc80895]

Say I have two MS-Access databases, mydb1 and mydb2. In mydb2 I have a macro "mymacro" that I want to execute against mdb1. Is it possible to start up MS-Access this way:



msaccess mydb1 /x mydb2:mymacro

First off I don't know if you can run a macro from a different database.

If it *is* possible, what is the correct syntax? (I just took a wild guess, since I couldn't find it documented.)

[R_Badger]

Crazy question, but have you considered just importing it?

I say this as I assume (as no other info was given) that the two files operate completely independently of each other ordinarily and aren't for example a back/frontend (although I'm not sure why you would want a macro in a backend, but saying that I have a table in my frontend files).

[hxc80895]

Well, the reason behind my question is that I have quite a number (hundreds, actually) of mdb's -- some large, some small -- that I want to run a macro against. I do not want to open each one interactively (I've got better things to do with my time!). The macro will extract procedures and table definitions in order to store them in flat files for easy searching among other things.

[R_Badger]

Knowing that is armed!

There *potentially* is a solution i can think of in the back of my head (half baked) it probably isn't quite what you envisaged, but it should work (as far as I can see you cant do it using command line switches), however you may be able to achieve it from vb.

You might be able to use the transferdatabase method (vb reference here) command to programmatically transfer it to your target database(s), and modify allenbrownes example code here to get the directory contents (assuming in this case they are all in the same place) then theoretically use shell filepath /x macroname to run it.

I haven't tried it, but it *might* work!