ODBC connection does not work via VBA

[hannlapp]

Hi.

It worked before but suddenly it wont anymore!
When I test in Control Panel my odbc connection to sql server, it works fine!
But in my VBA, it does not anymore recognize currentproject.connection.
Some windows update made it broken??

[ranman256]

try loading the table via odbc linked table. See if that works.

[hannlapp]

try loading the table via odbc linked table. See if that works.

Hi. How shall I do it in VBA?