No worries, i am just happy for the help.

The Linked Table Manager is greyed out. I have been have trouble finding where the access/database interaction takes place. When an action is preformed in access i can see that the database is being queried but i cannot find those queries in access. In some places the properties of an object in access show the query or view that is used but in other places that source seems to point to an existing object on a parent form.

Sorry for the vague response, I am the latest in a number of people to have worked on this project.