Microsoft Access problem: ODBC – connection to [DSN] failed -> can’t open the data in dataview sheet?

When i try to open a Ms Access linked table, it pop up the error as above. Does anyone know what cause this problem, thanks in advance.

5 Answers

  • Normally a DSN error means either the ODBC definition is missing or authorization credentials are not correct (login name and password).

    Go to Start | Settings | Control Panel | Administrative Tools | Data Sources (ODBC).

    Find the DSN you are connecting to and click Configure | Advanced. If there is a login name and/or password listed there, make sure it is correct.

    If that is not the issue, make sure the path specified to the database is correct. (Configure | Select)

  • This Site Might Help You.

    RE:

    Microsoft Access problem: ODBC – connection to [DSN] failed -> can’t open the data in dataview sheet?

    When i try to open a Ms Access linked table, it pop up the error as above. Does anyone know what cause this problem, thanks in advance.

  • This Site Might Help You.

    RE:

    Microsoft Access problem: ODBC – connection to [DSN] failed -> can’t open the data in dataview sheet?

    When i try to open a Ms Access linked table, it pop up the error as above. Does anyone know what cause this problem, thanks in advance.

  • Odbc Connection Failed

  • https://shorturl.im/uz85E

    God’s creativity workshop. Never shuts down.

Leave a Comment