Hi there,
Basically I was unable to 'crack' the MDE front-end of the database; but was able to crack the password protected back-end. Once in the back end I could view the relationships of the tables to gain the understanding I was after.
In addtion to that I also downloaded the 'Access Dependency Checker' Add In, which enabled me to report on field names and the link between tables and queries. Am still trying to figure out the forms/reports side of things as it doesn't want to analyse these (I assume becuase the front end is the MDE format).
I still want to be able to view the control data source for the forms/reports, the only way I have been able to do this (which is quite primative) is to look at the 'Object Dependencies' for each form/report and do a screen dump of each, then paste into word and print from there.... If anyone else has a suggestion I would be happy to hear it...(Im using Acess 2010 - on a MDE database, I dont have access to the MDB in which it was created).