Linked tables don't appear to be

[ryetee]

You can see the current trusted locations from Access with File | Options | Trust Center | Trust Center Settings | Trusted Locations. It is likely that your Documents folder and its sub-folders are set as trusted locations, which is why you were able to open the file once you'd moved it to there.

Thanks copied parts of your code. Had to changed a bit to fit my system and all is working so thanks for the help.