Richard,
I have been trying to apply the information presented in the seminar to build a make table query. My intent is to create a table in a another database. Every thing works with the exception of the IN statement: INTO [Project Directory] IN [ProjectPath]

[ProjectPath] is a text field derived from Launch CD command. It is the location of the database for the new table.
In this case it is: \DUAL\Central\PROJECTS\2014-07 USDB Salt Lake Center\00-General\Project Data\Project Data.mdb"

When I run the query I receive the following message: Could not find file'\\Dual\Central\ProjectPath'

Do you have any idea how i can modify the IN statement to recognize the full path name?

---

Reply from Alex Hedley:

You could just use the Linked Table Manager to link to the other db then use a normal INSERT.

Can you build up your SQL as a String and Debug.Print it before you run the command to see exactly what it says.
There is a space in the folder name you will need to quote the string.
I take it you can copy paste the full path into Explorer and it opens.