Do you mean reinstalling SSMS on the host server, client PC, or my admin PC?

I installed SSMS on the client machine and I can access the SQL Server database from there. Just not able to get Access to open with the ODBC tables visible...

If the question is - can I ping from the user's PC the server that hosts my SQL Server Instance containing the needed database? - the answer is yes I...

Do you mean pinging from the user's pc? What would be the best way to do this?

In my registry I have this for the database in question:

Description CE_DB
Driver   C:\Windows\SysWOW64\SQLNCLI11.DLL
Server   NBCP-SQL01-VM\NBCSQL01VM

So I changed my .reg file to read:

From Access when I was creating my ODBC connections I believe I chose SQL Server Native Client 11.0. Is there a way to tell for sure short of creating a...

System DSNs persistently fail when I try to create them.

In Access it is a User DSN with Integrated Windows Authentication which with the registry files has worked fine in SQL2005.

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"

I put SSMS on the User's machine and tried to login with Windows Authentication. I had to create the same user in the Database's Security node, and only then would...

I was able to get it working by correcting what I was naming in as the Logical Drive files, Data file and Log file. i tried to get the users...