Hmm. I am sure I've done it before and there was a checkbox for Always prompt for new location.
Otherwise what is the difference between Refresh and Relink?
@GPGeorge , thanks for the reply.
However, the edit becomes clickable when I select the whole group, it is greyed out if I just want to change one table.
Hi,
Not used the Linked Table Manager for a while and wanted to change the source for a linked table from MySQL but when pressing Relink it doesn't give me the option to change the data source location.
I am fairly sure it used to do this.
It just gives me a box to confirm the table name and...
I've been working on a Access database for last 20 years in my business, all self taught skills but I have zero database documentation. Having been self taught documentation never really came up.
It is an Access frontend with data stored in a local MySQL server and used by around 20 people...