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

  • February 13, 2018 at 9:48 am

    #1979617

    briancampbellmcad - Monday, February 5, 2018 6:41 AM

    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 to try the Access databases and they get an error: SQLState: ‘01000’, SQL Server Error: 53. I tried entering the Port 1433 that I read needed to be open and TCP/IP enabled but the error is still there.

    Sorry to be so late in responding, as have been away for an extended period.  It may help to take a look at the system tables in your Access databases - if you specified a version of Access, I missed it.  There is a system table called "MSysObjects" that has a field called Connect which contains the ODBC connection string that is used to connect to a particular SQL Server database.  You may find some information there that is relevant to your issues.

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!