Hi All,
I have a passthrough query where I would like to change the connection string using vba:
qrydef.Connect = "xxxxx"
After changing the connection string, although the query has a new query string, the query returns records from the old query connection string.
Only by deleting the original query, shutting down Access (not just the database) & compacting am I able to recreate the passthrough query with the new connection string.
The ODBC driver is Sage.
I have a passthrough query where I would like to change the connection string using vba:
qrydef.Connect = "xxxxx"
After changing the connection string, although the query has a new query string, the query returns records from the old query connection string.
Only by deleting the original query, shutting down Access (not just the database) & compacting am I able to recreate the passthrough query with the new connection string.
The ODBC driver is Sage.