check cd drive letter

[instructorTek]

Hi good day to all. I have an app done in MS Access 2002. Is there a way to determine the drive letter of the cdrom drive using VBA or using the windows API. I'm trying to determine this in the onClick event in a form.
Thanks in advance.

 

[snyperx3]

this might be helpful:

http://support.microsoft.com/kb/q180766/

-Pete

 

[alvechurchdata]

You can use the File System Object of the Windows Scripting Host to determine the type of any drive:

set fso = CreateObject("Scripting.FileSystemObject")
for each drv in fso.Drives
  if drv.drivetype=4 then
    msgbox (drv.driveletter & " is the CD")
  end if
next

Geoff Franklin

http://www.alvechurchdata.co.uk