Thanks in advance for any clues on this problem. I'm migrating several SQL Server databases from SQL2005 to SQL2016. One database is visible (I can connect to the tables) in a MS-Access frontend, and another database is not though I followed, I think, the same method for each. I retrieved a .bak file and loaded it on the C:\ drive of the host machine and from there I loaded it into SQL2016 using this script and all my tables are there with the expected data. The first line of code displayed that the logical data and log files were named ATCB_DB_Data and ATCB_DB_LOG and I can't seem to change that on my SQL2005 backup.
restore filelistonly from disk = 'C:\DATABASES\CPCE_DB_backup_201801290019.bak'
RESTORE DATABASE CPCE_DB
FROM DISK = 'C:\DATABASES\CPCE_DB_backup_201801290019.bak'
MOVE 'ATCB_DB_Data' TO 'D:\Databases\Data\CPCE_DB_Data.MDF',
MOVE 'ATCB_DB_LOG' TO 'D:\Databases\Data\CPCE_DB_Log.LDF',
The only other issue is when I go to the 'dbo' user it lists sqlAgentProxy rather than my active directory name:
/****** Object: User [dbo] Script Date: 1/29/2018 10:41:36 AM ******/
CREATE USER [dbo] FOR LOGIN [NBCC-US\sqlAgentProxy] WITH DEFAULT_SCHEMA=[dbo]
What I'm seeing in Access is this message: