Extensions, Extensions and more Extensions ACCESS just do it

R

rebelscum0000

Dear All,

I want to search for ALL the files which their extensions, looking in
my Entire HD
(In fact I only need the extensions and FileType),
With the following Criteria:
Searching system folders, hidden files and folders, subfolders, also
Windows Folder
Then I want to insert them into a tbl mm.. let's name AllExtension_Tbl
AND
No Duplicates allowed

In actual code I populate the tbl reading from a .TXT file, created
for a previous .bat file (Please do not ask me why is a long
history)

The problems are when my recordset finds FILES like:

..raidenftpd.acl

..raidenftpd IS NOT an extension!!

but .ACL IS an extension:

--
System Info for File Extension .ACL

Program ID:
ACLFile
aclfile

FileType :
AutoCorrect List File

EXEFile :
%ProgramFiles%\ACL Software\ACL Version 8\ACLWin.exe

--

Finally, I want to compare somehow with the following criteria

File Found:
..raidenftpd.acl

Search in the Tbl AllExtension_Tbl

Is .raidenftpd.acl is an extension I have in my actual HD or I have it
in the AllExtension_Tbl ?

IF No then

FileName = .raidenftpd.
FileExtension = .acl
FileType = AutoCorrect List File

IF Yes AND I do not have the extension in the Tbl AllExtension_Tbl in
order to compare then I have "The Problem" because my code
understands
File Name = Null <-Error
FileExtension = .raidenftpd.acl
FileType = <-Error

End If

I do not have idea how to do this any help, idea or suggestion are
more than welcome

Thanks in advance

Regards,
Antonio Macias
 
Top