Is there a method for updating ODBC string for pass through queries jerryk[ at ]insteptech.com 17.07.2006 23:08:30 Hi, I want to use a pass-through query to push execution of a query to my SQL server. The one issue i can see is that we sometimes move the SQL server database location. Is there a way to programatically update the ODBC string used by a pass-though query? Thanks, Jerry

Re: Is there a method for updating ODBC string for pass through queries "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 17.07.2006 23:34:22 Change the Connect property of the query. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) <jerryk[ at ]insteptech.com> wrote in message news:1153177710.589608.164140[ at ]75g2000cwc.googlegroups.com... [Quoted Text] > Hi, > > I want to use a pass-through query to push execution of a query to my > SQL server. The one issue i can see is that we sometimes move the SQL > server database location. Is there a way to programatically update the > ODBC string used by a pass-though query? > > Thanks, > > Jerry >