I work for a utility in the northeast. We have tons of material going back into the 80s. It is libraried with Access and we find that it works fine. Accurate inputting is the key. Quite a few years ago a secretary (who did not want to do the job) was assigned to input tapes. We ran into 2 problems: first, the inputting was very inaccurate, mis-spellings, wrong locations etc; the second was that she had no idea what was on the tapes and simply entered what was written on the box. We can all be a little sloppy in the field sometimes, “field tape 3” doesn’t really tell you much a few years later.
Much better to have a person involved with the shoot or project library.
Kevin
Kevin Sio
Videographer/Editor
Corporate Communications
National Grid