How to get MP4 Video "duration" into Access dB on XP PC?

[Mel_3]

On Windows XP Pro sp3 PC with MS Access 2003 &/or 2007

- Windows XP Explorer will not display the "duration" of mp4 video files
- But it does for AVI - and probably wmv

We have to be able to get the "duration" of mp4 video files
... into an Access data field... hopefully using VBA.

Can anyone help with this?
Hopefully with a demo code sample.

Thanks for any help.

PS - Win 7 Explorer does show "duration or "length" for mp4 video files but we need to find out how to make it work on XP machines.

[ajetrumpet]

check the video file in vba to see what the properties are first. loop them and print them out.

the other thing I thought when I read this was to simply google something like "mp4 convert file size to length", or something similar.

if you do that, you can get the conversion-based math. once you had that, vba would be easy, as you could simply read the file size and execute the math for conversion.