So you’ve got a Microsoft Access database with linked tables to a SQL server that looks something like this.
When opening one of the linked table you get an error that says, “ODBC–connection to ‘DP’ failed”.
When you click OK you get a message that says, “Microsoft Access can’t open the table in Datasheet view”.
Hmm, what up with the ODBC connection called “DP”? What say you Procmon?
Result = NAME NOT FOUND. Oh, the ODBC connection doesn’t exist. Create the ODBC connection & you are good to go.
I admit that you could have also just gone & looked at the ODBC connections in the Control Panel to figure out it doesn’t exist but it was really just an excuse to use Procmon.