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
-
God’s creativity workshop. Never shuts down.