Need VBA to check if folder access exists

[bharath744]

Hello,

Need to check if the user who has MS Access open has access to a particular folder in Windows directory.

ex:
If there are three folders
C:\Temp1
C:\Temp2
C:\Temp3
and I do not hav access to Temp2 folder, I require the vba code to prompt me or record the info in a table that i don't have access to Temp2 folder.

Thanks in advance.