I’m using Access 97 as a front end to a SQL database. I’ve created a user friendly query builder form for users to look at data both detailed records and as a grouping query. In general it has been working extremely well.
Recently I’ve run intoa situation when I received an ODBC failed message. It turns out that the pass through query that was created took longer to execute than the default of 60 seconds, so it failed.
What is the VBA code to change the ODBC timeout setting? Does it automatically affect all pass-through queries created in VBA code or is it part of the values for a specified queries?
