open table command

[Earlbowden]

We promot code for our client once a month, and most times database tables
change. I'd like to set up a macro to open the linked table manager (found
that command), and be prompted for table names (or portions of table names)
that need to be relinked.

Is that possible, without having to write code?

 

[Doug Robbins - Word MVP]

I assume that you are asking this question in connection with the use of
Access, not Word.

That being the case, you should ask the question in one of the
microsoft.public.access newsgroups as this one is for Word.

However, you can get the Linked Table Manager to appear automatically by
creating an Autoexec macro in Access that contains the Action "RunCommand"
and for the Command you select "LinkedTableManager"

The linked table manager will then display the tables that are already
linked to the database.

It sounds like very poor design to need to do this sort of thing however.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP