I installed SSMS on the client PC and the database and put the Access database on the desktop. Opened it and went into the Linked Table Manager and created a...

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...