Possible Shell command

[spectrum]

I am trying to use a program within Access if it's possible. It should be run from a command prompt (cmd) so I don't know if it's possible to do a shell alternative within an Access DB

The instructions I found to run are:

1. You need to have FFmpeg installed in order to create the thumbnails. The easiest thing to do is to unzip and paste the attached ffmpeg.exe into your \windows\system32 directory

2. Open a command-prompt window & navigate to the folder where your videos are located.3. Then type the following (everything in blue) Make sure you get it right!:

for %i in (*.mpg) do ffmpeg -i "%i" -f mjpeg -t 0.001 -ss 3 -y "%~ni.tbn"

4. Click "enter".

I am trying to make it work on files within c:\videos

Can anyone throw any light as to wether it can be done. Thanks

 

[DavidAtWork]

If you can't run the program direct from Access, you might be able to write a small batch file and run that using Shell command:

Dim strBatchName as String

strBatchName = "C:\BatchFile.bat"

Shell strBatchName, vbNormalFocus

David

 

[spectrum]

Thanks David, good idea I will give that a shot.