Hi, I am trying to put together a report for my management group that specifies what states and duration in state that certain Engineering Change Orders are in. The problem I am having is some members of management do not have access of EPDM for various reasons. Therefore using EPDM search is out of the question for those members; I am trying to come up with a solution using Microsoft Access to search, filter, and email a report every week or every time there is a change to the data set. I was wondering if EPDM has a dedicated file or table located somewhere in the installation directory that contains the metadata of all the files stored within a vault? I figured if a file like this did exist, I would be able to use it for the Access database.
Nikola, all the metadata is stored within the SQL server. I've never tried using Access to do what you are looking for and if someone has I would love to see it. I personally use excel to run several pivot tables that management who don't have access to EPDM can visually see.
If you are comfortable with a bit of SQL and VBA then look at the following post by Jeff Sweeney as a great starting point in achieving this.
EZ Enterprise Dashboard Graphs - 3DVision Blog