Linking the backend to the frontend

[Shawny]

I am trying to get a Db to work that is linked to 2 other Db files with tables. It doesn't work cause it has been moved. The front end does not list the tables with the little arrows in the window. The linking manager says there are no linked tables in the Db. The file names of the backend Databases are in the vba code everywhere in the Db where the tables are used. My idea is to just change the path, but where is the place where the path is listed? If the file names are everywhere, would there be only one place where the path name is typed in?

 

[Shawny]

It's me again. Maybe I can word this a little clearer.
Where in a database is the code to define a path to another db?

 

[chris_visible]

You can find the linked database from a table in the front end by viewing its properties. Do this by opening a table in design view and clicking on he properties box in the top left. The backend will be specified in the Description property.

If as you say the tables are no longer linked the to the back end then you will need to replace all the tables with linked tables from the back end. To do this delete all the tables that are also in the backend (otherwise they will be duplicated), then click file/Get new data/ Link Tables. Then specify the location of your back end and select all the tables you want to link.

I hope this helps.

 

[AnnaFoot]

Can't you just do it through the linked tables manager - tools > add ins > linked table manager. That's how i re-link fe to be after i have had to move them.

Anna