Unanswered: Problem with Shell Command in Access VB
This is the statement that I am having problems with;
Dim a As Double
a = Shell("msaccess \\Tpasan01\jwtest\STREAM\sbdats\Sbdat 2000.mdb /xAutoImport")
It is supposed to kick off a macro in another DB, but the problem is the other DB has a space in the name, and when I try to run the macro it does not recognize the space, so it comes back with an error that it can't find the DB.
I know that I could rename the target DB, but the problem is that the tables are referenced by several other DBs and I would have to fix them all.