Link to home
Start Free TrialLog in
Avatar of mlagrange
mlagrangeFlag for United States of America

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of als315
als315
Flag of Russian Federation image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mlagrange

ASKER

Thank you!