Microsoft Access problem: ODBC – connection to [DSN] failed -> can’t open the data in dataview sheet?
When I attempt to open a linked table in Microsoft Access, I encounter an error message stating, "ODBC – connection to [DSN] failed" and cannot view the data in the datasheet. Could anyone help me understand what might be causing this issue? Thank you 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.
Related Questions
Have you ever noticed how the rear wheel of a bike seems to follow the front wheel closely? Why does this happen, and is...
What does CSS stand for: Cybernet Slash Support or Cybernet Software Systems? I came across a company located in T. Naga...
Today's CPUs operate at speeds measured in gigahertz rather than kilohertz. Is this statement true or false?
What view in a presentation program allows you to display your slides in full-screen mode?
I played Wizard101 on my other computer alongside some other games, and I had a lot of fun. However, my computer ended u...
I recently purchased a new PC, and as is often the case, it came with trial versions of Microsoft programs. Specifically...
What are the advantages and disadvantages of locally installed software? Could you please provide a detailed overview of...
I am experiencing an issue with my LCD monitor, which shuts down automatically after a few minutes of use. I would like...
Does the Xbox 360 support playback of Blu-ray discs?
I’ve wanted to try a pair of Beats by Dre headphones for a while, but I’ve been debating whether the price is worth it....