Unanswered: prog.ly supply path to make-table query
Is there a way to programmatically supply a path to a make-table query that will put the new table in an external access database?
also, would need to supply the database password for the external database.
My take on this would be to automate the remote db (supplying the password when you reference it) and use a make table query in your automated database. I would just execute it as a DAO.Database execute. SQL something like:
SELECT * INTO MyewTable
FROM Table1 IN 'C:\Remotedb.mdb'