The subject says it all;

I'd like to be able to programmatically open up a filepath "c:\...\TMP.mdb"
into MS Access.
What's the command line for this?

Thanks.

this should be close, if not check the help for the methods mentioned:

dim db as database
dim rs as recordset

        set db = opendatabase("c:\tmp.mdb")
        set rs = db.openrecordset("select * from SomeTable")

        ....

I believe that you are looking to launch MS Access with the file listed?  If
that is the case, you can use Shell() if you know the path to access or you
can use the ShellExecute() API that has been listed many time on this
newgroup (mostly for people launching a .htm file into the default browser).
If you can't find it, someone or I can repost the info.
jc