Using Macros To Link Tables

[shuff]

I don't see this one already posted, so heeeere we go.

I want to be able to link external tables programmatically by using a macro to do the linking. The macro would be fed table names and I want it to make the links, looping back to repeat until it runs out of values/table names. My specific question is -- how do you call the linking process from within the macro? I know about the Run Command | Link Tables option, but it just presents a dialog box to browse to the table - same as if I were to do it manually. I don't want to see the dialog box - I want to to supply the table name as a variable, then have the macro do the link. Seems simple, but I don't see a way to do this. Can anyone tell me what I am missing?

Thanking you in advance,
Scott/Chicago, IL USA

 

[HiTechCoach]

I am not sure that a macro can be used to do this. In all the years I have been working with Access (since 2.0 came out) I have never seen a macro that could do this. A macro could possible be used to call VBA that can do it programmatically.

See if this helps:

Relink Access tables from code

and also form

Swap/Relink Between LIVE, TEST and LOCAL Data

Hope this helps ...

 

[shuff]

Thank you sir - I will check these out.

SLH