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

Question

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.

Answer 1

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)

Answer 2

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.

Answer 3

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.

Answer 4

Odbc Connection Failed

Answer 5

For the best answers, search on this site https://shorturl.im/uz85E



God's creativity workshop. Never shuts down.