I have a SQL computer with SQL database and use the Linked Table Manager to link SQL tables into the Access database.
It works fine. But when I copy this accdb file to another computer (on the same network & can ping the SQL computer), it fails to run.
I need to remove all the linked tables and re-create them again, then it works.
How to just copy the accdb from the SQL computer to any networked computer, then it works?