Linking question

[SGT68]

Been developing this admin system for a charity. I've got the forms and queries in one .accdb file and my tables in a separate .accdb file. The forms file links to the tables in the tables file. The tables file resides in a folder called simply enough C:\acc_tables and thats where i browsed to (obviously) when i set up the linkage.

One of the users does not wish (for whatever goddamn reason) to create a C:\acc_tables file to stick the tables file in , and wants the tables file in some other folder.. Unfortunately this user does not have the skills to delete the existing links and re-link to the tables file after putting it in the folder he wants.
So.. my question is:

Where in the file that holds the forms and and queries do i find the path setting to the tables linked file? Can it be changed without deleting links and then re-linking?

 

[gemma-the-husky]

you should find an option called "link table manager"

you browse to the new backend database, and select the tables you want to link. It should do all at once, but the last couple of times I used it, you had to do it one at a time, and I couldn't understand why.

I usually link with code, so it's never normally an issue for me.

 

[SGT68]

you should find an option called "link table manager"

you browse to the new backend database, and select the tables you want to link. It should do all at once, but the last couple of times I used it, you had to do it one at a time, and I couldn't understand why.

I usually link with code, so it's never normally an issue for me.

Thanks - i didn't see the Linked Table Manager before. That did the trick
nice dog btw

 

[CJ_London]

should do all at once, but the last couple of times I used it, you had to do it one at a time, and I couldn't understand why.

When this has happened to me it is because I've selected all and they are not all in the same file - had a rogue link to another file to a table no longer used

 

[gemma-the-husky]

When this has happened to me it is because I've selected all and they are not all in the same file - had a rogue link to another file to a table no longer used

bang on, CJ. That's exactly the situation. I am sure you are correct.