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??
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??
try loading the table via odbc linked table. See if that works.