locked
VBA to link new table from selected back-end file RRS feed

All replies

  • I'm not familiar with the FE Updater file in question, but generally, to update a front end in the event of a back end file being relocated or renamed, code would be executed in the front end at start-up to check the validity of existing links and refresh these where necessary.  You'll find examples in Refresh.zip in my public databases folder at:

    https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169

    Where the back end is a single Access file the RefreshLinksSingle_07.accdb file is the appropriate example.  In this, code in the opening form's Open event procedure examines the current links and, if these are invalid, opens a simple dialogue form in which the user can browse to the current back end to refresh the links.  I've used this method in countless files which I've distributed over the years, and it's always been foolproof.  The user only needs to do this at first start-up of course.  Subsequently, unless the back end is moved or renamed, the links will be correct.

    Ken Sheridan, Stafford, England

    Tuesday, June 30, 2020 11:16 PM