Split tables

[dmyoungsal]

I have a split DB that I want need to copy and use in a different manner.

The new use will be putting a version of the DB on indvidual laptops (sales) so they can use a price tool program. This will require copying the current FE and BE DB's to a new name - "blahblah-be - Sales" and "blahblah - Sales"

the issue I am having is how can I point the new FE to look at the new BE

I have looked at the linked table manager at the only thing I see are links to two external CSV files that I use.

 

[isladogs]

The easiest way would be to temporarily have two copies of the BE in the old & new locations.

Relink using the linked table manager then DELETE the version in the old location

If that's not feasible, you'll need to use VBA to do the relink.
I have code for this but its lengthy & would need to be extensively modified for your setup

 

[Pat Hartman]

Here is a relinking form that will give you a start. You can incorporate this and let the user do it or you can force the user file structure to be fixed to what you use on your PC and relink it yourself prior to sending the FE and BE to the user.