Search results

thanks.

Does this mean that if I link a shared Access front-end to SQL Server tables on a new workstation using a particular ODBC driver that that won't affect the links that other workstations have to the SQL Server tables using a different ODBC driver (again all within one shared Access file)?

P.S. My clients are generally smaller shops, max 10-20 stations.

Yes, I know this advice but it makes for more complicated roll-out of updates. I've never had any problem sharing one front-end file. So, confirming, there cannot be one front-end Access file linked via different (per station) ODBC drivers to SQL Server, presumably because the ODBC driver...

I'm trying to get an additional PC on a network of Windows 10 computers with an 32-bit Access (365) front-end connected via ODBC to SQL Server Express (version 11) that all use ODBC Driver 13 for SQL Server. The added PC runs Windows 11. When I try to install that ODBC driver it says it's...