Geek Answers Handbook

MS Access: Linked tables - how to get a connection string when a linked table manager is not installed

I am looking for a database while its author is on vacation. There is no related table manager on the server on which it is running, and db gives me an error - "ODBC - connection to" XYZ "failed." when I try to execute a Domd.OpenQuery query depending on a linked table.

I get the same message when I try to open the specified linked table. How do you know what this indicates?

+6
ms-access
source share
3 answers

Open the table in development mode, accept the warning with “Yes”, look in the “Properties” window of the table (and not in the column in Access 2007, the table properties window is docked to the right - on the right side of the window, in earlier versions there is a button on toolbars, if I remember correctly). The Description field contains the ODBC string for the table.

+13
source share

You can use the connect property. in the nearest window:

?CurrentDb.TableDefs("LinkedTableName").Connect

The property is being updated.

+12
source share

Implement access tables from code

+1
source share

More articles:


All Articles