How can I programmatically change the ODBC connect string for a pass through query?
P Peggy Oct 2, 2003 #1 How can I programmatically change the ODBC connect string for a pass through query?
R Rick Brandt Oct 2, 2003 #2 Peggy said: How can I programmatically change the ODBC connect string for a pass through query? Click to expand... One option using DAO... ******************** Dim MyDB as Database Dim MyQryDef As QueryDef Set MyDB = CurrentDB Set MyQryDef = MyDB.QueryDefs("YourQueryName") MyQryDef.Connect = "Your new Connect String" MyQryDef.Close Set MyQryDef = Nothing Set MyDB = Nothing
Peggy said: How can I programmatically change the ODBC connect string for a pass through query? Click to expand... One option using DAO... ******************** Dim MyDB as Database Dim MyQryDef As QueryDef Set MyDB = CurrentDB Set MyQryDef = MyDB.QueryDefs("YourQueryName") MyQryDef.Connect = "Your new Connect String" MyQryDef.Close Set MyQryDef = Nothing Set MyDB = Nothing
