Home Forums Microsoft Access Microsoft Access Migrated DB to 2016, having ODBC Access problem RE: Migrated DB to 2016, having ODBC Access problem

  • January 31, 2018 at 3:16 pm

    #1978110

    Steve Jones - SSC Editor - Tuesday, January 30, 2018 3:32 PM

    Can you go back and verify the names on source databases? The logical name wouldn't change unless you changed it in a source. At least AFAIK.

    The permissions thing comes from your error in accessing the object. If the object is there, and you can't access it, then it's usually permissions.

    Don't the Users and their permissions copy over also? I've combed through any differences between the SQL Server 2016 migrated database I can see from Access and the one I cannot and I'm not seeing any permissions issues.

    After restoring to 2016 from a .bak file I can read all the data from SSMS on each attempt and I've tried 6 different databases. Again one is visible from Access (Linked Table Manager) and 5 are not.

    I've tried to locate what is special about the one that consistently succeeds and I cannot find anything. All the users are recreated from the .bak file.