0

I have a task to move linked tables to another network drive. There are 13 stores and each store uses its own database as using the code how can re-link the tables to a specific database.

Thanks

Improve this question
7
  • Each store has its own copy of same frontend or each has their own unique frontend? If the first, could just use the Linked Table Manager to set new links then redistribute frontend to users; if the latter each will have to use Linked Table Manager to set new links. Commented Oct 4, 2021 at 18:06
  • Each store have own unique. With "Linked Table Manager" it's hard because there is around 70 tables and each using differend database Commented Oct 4, 2021 at 18:11
  • VBA can change link paths (stackoverflow.com/questions/36899011/…) and VBScript can connect to and manipulate Access file (stackoverflow.com/questions/40999718/…). Might be able to build a script (VBScript, PowerShell, etc) that could connect to and open each file and modify links. Not something I've ever tried. Commented Oct 4, 2021 at 18:13
  • I'm trying to use this code (excelsirji.com/vba-code-to-re-link-ms-access-link-tables) but when code found a database where is in different location i got a error Commented Oct 4, 2021 at 19:33
  • Maybe there some fix where skip that tables then check next table? Commented Oct 4, 2021 at 19:36
Related questions
0
Connect to a linked table
0
Link multiple tables from one database
6
Relinking database tables: Access, VBA
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.