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

  • January 30, 2018 at 4:09 pm

    #1977976

    briancampbellmcad - Tuesday, January 30, 2018 3:46 PM

    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.

    The logical names are from the databases on the source server and they are misnamed... how to rename them has evaded me.

    It's not going to matter at all for restoring. What's in the backup is what you would use for the restore. It is what it is.
    After you get it restored, you can rename those logical files. Using t-sql it's just alter database...modify file. You can also do it in Powershell, SMO if you'd rather. There is an article up here that demonstrates each of those:
    Changing SQL Server Database Logical Names

    Sue