I am using Access 2002.
I have many database files with 100's of linked tables. I have a routine that updates the links depending on the 'home' directory for the version of the database that I am working on.
Recently we were asked to add user level security to the files. Then we were asked to remove it. We have reset all permissions on objects to allow all users to do everything, then deleted all users other than Admin.
We can then open the file using the normal System.mdw
Now the update links will not work unless the old mdw file is used, even though all permissions have been reset.
The KB has errors for Acc97.
How can I make the links update using the default mdw?