Macro to execute Linked Table Manager -> Refresh RRS feed

  • Question

  • Is There anyway to make a macro (like Excel) to mimic the key strokes to bring up the "Linked Table Manager" to "Select" to "Refresh" option in Access?

    Thx in advance.

    Wednesday, December 11, 2019 9:25 PM

All replies

  • RunMenuCommand > LinkedTableManager

    this only works if you actually have linked tables.

    This opens the LTM. The rest is up to the user and not available in the super simple macro language. If you want to do better, VBA is the only way.

    -Tom. Microsoft Access MVP

    Thursday, December 12, 2019 2:45 AM