[AccessD] DSNLess remote tables return 'dbo' for user_name()

[Stuart McLachlan]

> still on SQL Server 2008.

Ouch!  ver 17:   "works with all currently suppported versions of SQL Server."
2008 is no longer supported.
2012 Extended support ends Dex 2022.

Best to stay with Ver11 or 13 for now. 


On 10 Apr 2021 at 8:37, Ryan W wrote:

> I just checked the big cheeses machine (he barely does anything on it)
> and does NOT have the ODBC Driver 17 loaded... so apparently even
> Windows 10 just comes with the base driver.  Which is probably the
> reason I've kept using DRIVER=SQL Server for so long, because it's the
> least common denominator and does not add dependencies when rolling
> out the app when we upgrade workstations.
> 
> I'll have to consider whether the move is worth it, if it's just for
> compatibility with new datatypes, at this time it's not a problem
> since we're still on SQL Server 2008... but have plans to move to SQL
> Server 2019 within the year.
>