Linked tables

[Jaye7]

Currently I have a script which changes my linked tables from one location to another and it works well.

The problem I have is that I have a table in one back end named Orders and I linked it into my other database and changed it's name from Orders to AdminOrders, as we already have a table named orders.

This is the case for numerous other tables also.

So I don't know have to change AdminOrders to then link back to Orders when I change the links from one location to another.

So my linked table location is currently X:\, the new location is X:\Test.

When I try to link it I get an error as the table in X:\ is named AdminOrders, whereas the table in X:\Test is named Orders.

 

[Jaye7]

I worked it out, I need to import the Orders table into my backend as a linked table then change it's name to AdminOrders and do the same for the other backend that I will be relinking to.

 

[emare]

Currently I have a script which changes my linked tables from one location to another and it works well.
...
..
.

I'm looking for such a script.
Would you please be so kind to share the script and let me know some more details ?
I thank you so much.