Question posted 2009 · +4 upvotes
I’m looking after a database while its author is on holiday. The server it’s running on has no linked table manager, and the db is giving me an error – “ODBC –connnection to ‘XYZ’ failed.” when I try to Domd.OpenQuery a query that’s depending on a linked table.
I get the same message when I try to open said linked table. How do I find out where it’s pointing to?
Accepted answer +10 upvotes
Open the table in design mode, accept the warning with “Yes”, look into the “Properties” window of the table (not the one of the column — in Access 2007, the table properties window is docked on the right-hand side of the window; in earlier versions there’s a button in the tool bar, if I remember correctly). The “Description” field contains the ODBC string for the table.
Top ms-access Q&A (6)
- How can I modify a saved Microsoft Access 2007 or 2010 Import Specification? +31 (2008)
- OleDbCommand parameters order and priority +28 (2009)
- Is there an equivalent to the SUBSTRING function in MS Access SQL? +26 (2009)
- What do I need to read Microsoft Access databases using Python? +25 (2009)
- MS Access library for python +24 (2009)
- is there any replacement of Access? +21 (2009)
ms-access solutions on this site
.