Is it possible to delete external files witha query?

Is it possible to delete external files witha query?

Post by PSI » Wed, 17 Sep 2003 07:08:38


My access database has a table where one of the fields is an external
filename ( large map images ). Is it possible to construct a DELETE
query which will automatically delete the external files or does one
do a SELECT first, iterate over the records deleteing the external
files and the do a DELETE query with the same criteria.

Thanks
Frank
 
 
 

Is it possible to delete external files witha query?

Post by Joe Fallo » Wed, 17 Sep 2003 10:33:05

The latter.
--
Joe Fallon
Access MVP