HELP PLEASE This Is a tough one!

[VBDever]

Help!

I have an application that looks for data files to come into a directory. Once a file enters the directory, its name is checked against a database to see if it has a corresponding executable. If it does, the application kicks off the corresponding 2nd executable.

For example joe.dat kicks off joe.exe

This 2nd execuatable reads the data out of a flat file into a SQL 7 db using ADO.

Here is my problem. When I run the first application it may well kick off up to 10 different 2nd applications because there might be up to 10 different files in the folder. These applications are all updating and appending to the same table in my Sql7 db. I am anticipating record locking issues and watching the system bomb out. does anyone have any suggestions that would let me use what I already have and queue the 2nd applications so that I don't run in to record locking issues?

[Lafor]

Simply,
Once the app finds that a file has a corresponding .exe
Shellsmart that executable i.e do not look any more until
that application is done running...
If it is done, then grab the next file and do the same thing

Shellsmart would get a handle on the kicked off application
and doevents until the process is released