For the users to open Access they have to have a .reg file imported to their machine that looks like this:
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\CE_DB]
"Driver"="C:\\Windows\\system32\\sqlsrv32.dll"
"Server"="NBCP-SQL01-VM\NBCSQL01VM"
"Database"="CE_DB"
"LastUser"="williams"
"Trusted_Connection"="Yes"
The entry "NBCP-SQL01-VM\NBCSQL01VM" may be a problem - "NBCP-SQL01-VM" is the name of the virtual server machine, whereas "NBCSQL01VM" I think is the name of the instance, BUT
In SSMS the server name is indeed "NBCP-SQL01-VM\NBCSQL01VM"