deleting redundant pictures based on database information

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a folder with some 6,000 jpegs and a datadace with some 2,000 entries.
The picture filename and database id record match. How do I match the two
pieces of information and delete those wich do not match ie approximately
4,000 jpegs?

tia
 
I don't know of any Access feature which would control the deletes of jpegs
in another folder.....sorry
 
You could make a table with all the existing file names in that folder
(Check the DIR function in the help file for how you might do this).

Once you have filled the table, use an outer join query to identify the
files with no corresponding entries in the database, and then delete them.

This is just off the top of my head - but it's a start (I hope!)

If I have made too many assumptions (!) about your level of expertise,
let me know - I can give you more details.

John
 
Back
Top