split database

[slyvsspy]

I have a split database in a folder on my c: drive. I want to move the database to another folder, but it keeps trying to find the data from the other folder.

Can anyone tell me how I can change the data source to point to the new folder??

Thanks so much.

 

[scottfarcus]

Delete all linked tables (those with an arrow).

Right-click in white space and select Link Tables.

Find new data location and link tables.

 

[Sohaila Taravati]

You can go to the linked table manager and point your tables to the right direction

 

[antomack]

Use the 'Linked Table Manager' under Tools/Add-Ins for A97 or Toots/Database Utilities on A2K. This will open a window to allow one to select the linked tables and then refresh the link by pointing to another location.

 

[scottfarcus]

I stopped recommending the Linked Table Manager because not everyone has it installed.