I've had a doubt for a while now, not sure if this has already been answered in a different context or thread.
If in the event the location of a BE changes or the folder structure that contains the BE and/or FE changes, how could I avoid having to manually re-link the tables again? As in is there a way for Access to recognise this change and update the linked tables automatically or is there some VBA involved perhaps?
If in the event the location of a BE changes or the folder structure that contains the BE and/or FE changes, how could I avoid having to manually re-link the tables again? As in is there a way for Access to recognise this change and update the linked tables automatically or is there some VBA involved perhaps?