The problem is not about a coding issue, or linked tables or any fault of your own.
I'm guessing you're coding and running your app on Windows 7, right? If this is true (why would it not be, if you're on SevenForums?), then it's because you're putting your Access database file into a subfolder of "Program Files", which on Vista and Windows 7 is classified as a protected folder, with restricted access to usually Administrator and Trusted Installers. This is by design to help prevent unauthorised programs (malare and such) from making changes they shouldn't.
If your MDB file is in some user folder, such as Documents, or some other user-created folder, then you wouldn't have a problem.
It'll take a bit of getting used to, but you'll have to recode your applications to run from "Program Files", but to locate any and all data files into a user folder.