Select Statement via DSN

  • Thread starter Thread starter taccea
  • Start date Start date
T

taccea

How do I run a SQL select statement via the DoCmd.Run SQL method/action
through a DSN to a SQL2000 database to make 3 Access2000 tables.

ThankYou

Taccea
 
Easiest way would be to create a linked table that uses the DSN, or a
pass-through query that uses it. You would then base your make-table queries
on that linked table or pass-through query.
 
Back
Top