Converting LOTS of Access queries to Pass through Queries (T SQL) for sql server

[mrbg07546]

I am just using SSMA for migrating my access database to sql server.

using the wizard it migrated the tables to as linked tables.

I have LOTS of sql queries which i want to convert to pass through, is there a quick way to do this?

Kind regards

 

[Galaxiom]

Change the Type property of the QueryDef to dbQSQLPassThrough and enter an appropriate connection string in the Connect property.

This can be automated using a loop through the QueryDefs Collection with some technique such a a naming pattern to nominate the queries to be converted.