Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

ODBC linked table DAO Connect property broken.

Copper Contributor

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.

4 Replies
MSFT is aware of the problem and a fix will be available at the next Patch Tuesday.
Thank you, but I have users who need a working system on Monday so I'm still going to lose my Sunday rolling out a workaround.

Why on earth was Microsoft even messing around with something which is (frankly) obsolete and has been stable for literally decades?
If you have mission critical software, you should not be on Current channel. Let others deal with the bugs, while you sit pretty on Monthly or Semi-Annual Enterprise Channel.
The missing semicolon was probably an unintended result of another unrelated change. There is no evidence so far that MS was 'messing around' with connection strings. From my tests, both DSN & DSN-less links created in code or through the LTM still work though the connect string is clearly wrong in the Immediate window. However, if links no longer work for you, I'd suggest rolling back to v2311 rather than rewriting code
Also, in what way is it 'frankly obsolete'?
Suggest you read the article at https://www.accessforever.org/post/missing-semicolon-in-odbc-connect.