S
Sue
We recently had to change our server and my ODBC connections are incorrect.
I have found the following command
ActiveSheet.querytables(1).connection = "ODBC;DRIVER=DEBUG KISAM 32 bit
driver;UID=username;;SERVER=xxxxxxxx;DBNAME=ODBC;LUID=username;"
This corrects the problem but on one sheet at a time. I may have 5 sheets
in one file running queries, is there a command instead of active sheet, that
will update all sheets in the workbook?
I have found the following command
ActiveSheet.querytables(1).connection = "ODBC;DRIVER=DEBUG KISAM 32 bit
driver;UID=username;;SERVER=xxxxxxxx;DBNAME=ODBC;LUID=username;"
This corrects the problem but on one sheet at a time. I may have 5 sheets
in one file running queries, is there a command instead of active sheet, that
will update all sheets in the workbook?