Linking - Select Location

[Tom Ventouris]

I have removed some disused tables from both the BE and FE in a split SB.
Since this change, I am prompted to specify a location for each table when
refreshing the links. This despite selecting "All" and specifying the New
Location.

Is there an alternative to creating a new DB, importing all objects from
both the FE and BE and splitting it?

 

[John W. Vinson]

I have removed some disused tables from both the BE and FE in a split SB.
Since this change, I am prompted to specify a location for each table when
refreshing the links. This despite selecting "All" and specifying the New
Location.

Is there an alternative to creating a new DB, importing all objects from
both the FE and BE and splitting it?

I'd guess you still have some links in the frontend pointing to
no-longer-in-existance tables in the backend.

Make a backup of the frontend, then delete all of the linked tables in the
frontend. You're just deleting links, not the tables themselves.

Then use File... Get External Data... Link to link to the current set of
tables in the backend.

It's possible that you might have some code or combo boxes referenceing those
tables, but that should not cause this particular error.

 

[Tom Ventouris]

Thank you.
Nice and simple. After the fact, it all seemed too obvious