Vladan,

Sorry,  I posted it twice by mistake.  

Thank you all anyhow...

Andy,

I tried this and it work

"SELECT     A.FileName, A.Path + A.Directory AS [Physical Location], A.Description, A.QQID, A.Client_ID

FROM         DatabaseImagesList A LEFT OUTER JOIN

                      DiskImagesList D ON D.DiskFilename = A.FileName

WHERE     (D.DiskFilename IS NULL)

ORDER...

Ramesh,

Thank you for your query, according to your query result, I found the imagefile on the hard drive(diskimagelisttable).  The fact is that I don't want to see the imagefile from DiskImagesList.Folder...

Thank you for your help!!!

I dowload SQLServer2005_DTS.msi in order to export SQL Express to Access Database.   The job fail on me many times is there another way to do it via ADO?

EdVassie,

Would you e-mail me copy of the scrip and documentation.  I greatly appreciated!