Deleting unfound external files

[John]

Hi

How can I do this programmatically;

1. Read the first file in a folder.

2. Search for its path+name in a field in a table.

3. If not found, delete the file in the folder.

4. Repeat from step1 until all files in the folder checked.

Thanks

Regards

[Tom van Stiphout]

On Thu, 8 Jun 2006 14:51:17 +0100, "John" <Jo**@nospam.infovis.co.uk>
wrote:

Write a loop and use the Dir function to check for files. This will
successively find all files. Then use the DLookup function to check if
that file exists in your table.
Happy programming.

-Tom.

Hi

How can I do this programmatically;

1. Read the first file in a folder.

2. Search for its path+name in a field in a table.

3. If not found, delete the file in the folder.

4. Repeat from step1 until all files in the folder checked.

Thanks

Regards

[CDMAPoster]

John wrote:

Hi

How can I do this programmatically;

1. Read the first file in a folder.

2. Search for its path+name in a field in a table.

3. If not found, delete the file in the folder.

4. Repeat from step1 until all files in the folder checked.

Thanks

Regards

This is similar to a recent question in microsoft.public.access:

http://groups.google.com/group/micro...d5d8f41dd1235e

I.e., please read up on the difference between cross-posting and
multi-posting.

James A. Fortune
CD********@FortuneJames.com