How to MakeTable to another database?

Hello - I need to run MakeTable queries in a split-database front end that makes the tables in the back end.

I see the DestConnectStr/DB/Table properties in the Query Design property sheet, but where are these prop's if I want to set them in VBA, and run the query via a QueryDef .Execute?

Thanks
mlagrangeAsked:
Who is Participating?
 
als315Connect With a Mentor Commented:
You can use this syntax:
Dim SQL As String
SQL = "SELECT * INTO [MS Access;Database=C:\Database.mdb].Table1 FROM Table1;"
CurrentDb.Execute SQL, dbFailOnError

Open in new window

0
 
mlagrangeAuthor Commented:
Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.