RE: Access 2003
I have linked to a SQL Server database and have the tablenames from
this database in a local lookup table called "tblSQLServerTables".
When looping through this lookup table in a recordset, how do I
dynamically create (via VBA) a make table query for each of the
tablenames in tblSQLServerTables?
When a make table query runs, there's the prompt to "insert x number
of rows into a new table?". Will "Set Warnings = false" eliminate
that message from appearing?
Thanks.