that worked... thanks!!

My bad... It does allow me to specify a default database. Let me try again.

I went into the ODBC Datasource Administrator on my VM and created a User Data Source called CPCE_VM using the ODBC Driver 13 for SQL Server since I'm guessing that...

I must not have followed something correctly. I Created a DSN called CPCE_2016_Copy on my machine, found that file and in regedit copied it over to the registry on the...

System or User DSN... and all that does is connects to my SQL Instance right? How do i get to the databases inside it?

You mean the ODBC from control panel as opposed to that in Access?   ~  "Control Panel\All Control Panel Items\Administrative Tools\Data Sources (ODBC)"

The database in its previous instance on SQL 2005 did not have the only user of the database CPCE_DB, Ms. Hall, nor any other users except Guest, Dbo, and Sys....

I ran this: exec sp_msloginmappings 'NBC-US\databasetest' and exec sp_msloginmappings 'NBC-US\campbell' both of which list myself 'campbell' and 'databasetest' as usernames mapped to DBName CPCE_DB. What additional information can I provide to clarify...

'databasetest' is a user setup for testing. They have a network login using that name and a password as they are in our active directory. To login to SQL Server,...

Here's right-clicked on the User on the Security>Logins node:

When in Access using the LTM it will take me as far as seeing the system tables for the database but not the data tables.

I'm using or rather allowing Windows Authentication for each user. I'm using Access 2010. I have checked my test user and they have read/write privileges to the database. The user...

Here's what's in the MSysObjects Connect field: DSN=CPCE_Copy;Description=CPCE_Copy;Trusted_Connection=Yes;APP=Microsoft Office 2010;DATABASE=CPCE_DB;