Linked Table Manager Macro

[Guest]

I need to prompt a user to relink a table every month. I need to create a
macro that opens linked table manager and prompts for a new location.

Any help would be great.

Thanks

D

 

[Douglas J. Steele]

This sounds like an uncommon requirement! You might want to post some
details, and someone may be able to suggest a better approach.

In any case, I don't believe you can do it using macros: you'll need to use
VBA. There's sample code for relinking tables at
http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web". You could
have a table that stores a single field: last time tables were linked. When
you open the database, you could compare the month in that field to the
current month. If they're not the same, invoke the relinking code.

 

[Guest]

Unless there is an overriding requirement to relink tables monthly, then I
would suggest setting your database to Compact On Close. If it is necessary
to do the monthly relink, like your database changed each month, then Douglas
J. Steeles' recommendation is the way to go.