Can you point me in the right direction

[DrMike]

So I need to find a way to verify paths that exist in a column of one of my db table for example Table: S_T Column:S_MPEG_Name

In this column exists information that points to certain files for Ex:

C:\Video\08_22_2008.mpg

I am hoping for some advice on the best way to verify that the file exists in this location some sort of verification tool.

What would be the best programming language to create an application that would allow me to do this?

Or do you know of a utility that exists that is capable of this?

Thanks in advance

 

[RuralGuy]

The Dir() function will let you know if the file exists. Look in VBA help on how to use it.

 

[boblarson]

DrMike:
Double posting is not something we like here. Please do not do it again. If you think you posted to the wrong area let one of the moderators know by reporting the post using the exclamation mark in the red triangle at the top of the post.