Access Audit

[PhilJ]

Is there any way i can create an access db that will monitor a
drive/file/folder and log who accessed what and when etc?

 

[TC]

There are Windows API's that will notify you of such changes:
http://msdn.microsoft.com/library/d...-us/fileio/fs/findfirstchangenotification.asp

But it's another uestion whether you could call those APIs, from VBA.
Maybe a search like this would pick something up:

findfirstchangenotification "declare function"

HTH,
TC