I'm looking for opinions on the easiest way to achieve a task
Some years back I inherited a database. It was obvious from the outset that it had various problems, but I've been too busy adding new reports for management and 'firefighting' small problems to do anything much about it. Now it looks like I might be able to spare some time on it, but where to start?
I know there are dozens of forms, queries, tables, etc. that are either not in use or should be improved (data isn't normalised in any way, for example). Is there some application anyone knows of that can automatically provide a list of at least some connections e.g. report A needs query B which gets data from tables D, E and F. I'd like to get a list of the items I can safely delete, without spending the time checking each item manually.
Once I've removed the superfluous stuff, I figure I can change the remaining queries and reports to the point where it'll allow me to change the table structues and normalise the data.
Some years back I inherited a database. It was obvious from the outset that it had various problems, but I've been too busy adding new reports for management and 'firefighting' small problems to do anything much about it. Now it looks like I might be able to spare some time on it, but where to start?
I know there are dozens of forms, queries, tables, etc. that are either not in use or should be improved (data isn't normalised in any way, for example). Is there some application anyone knows of that can automatically provide a list of at least some connections e.g. report A needs query B which gets data from tables D, E and F. I'd like to get a list of the items I can safely delete, without spending the time checking each item manually.
Once I've removed the superfluous stuff, I figure I can change the remaining queries and reports to the point where it'll allow me to change the table structues and normalise the data.