ODBC linked table DAO Connect property broken.
This just cropped up on one computer. I expect to see it on more. Obviously a broken MS update. For an ODBC linked table, the DAO Connect property (of the TableDef object) returns the connection string. It's broke. The string is supposed to begin thus (and always did so): "ODBC;DRIVER..." Not any more it doesn't, not on this one machine, it now begins "ODBCDRIVER..." (missing semi-colon) which makes it an invalid connection string. If you look in MSYSOBJECTS, the connection string begins "DRIVER". No "ODBC". So, "ODBC" is obviously prepended by DAO when the Connect property is referenced. But now it fails to prepend the semi-colon. Easy to fix. Just replace "ODBCDRIVER" with "ODBC;DRIVER". Annoying though: I have a bunch of live systems which now need to be fixed. Hoping this helps someone.