Solved DriveExist error

[The Rev]

Trying to see if a drive is mapped before I run some code on that drive path from my database. It may be empty so fileExists or FolderExists won't help. It's supposed to work simply, but I'm getting the" Object doesn't support this". Banging my head against the wall....

Set objFSO = CreateObject("Scripting.FileSystemObject")
If objFSO.DriveExists ("R:\") Then
     Msgbox "R Drive mapped", vbOkOnly
End If

Why isn't it working?

 

[June7]

What happens - error message, wrong result, nothing?

The method works for me. If you want to provide a message for both results:

MsgBox "R Drive " & IIf(objFso.DriveExists("R:\"), "Mapped", "Not Mapped"), vbOKOnly

 

[theDBguy]

It works for me too. Which line is highlighted when you debug?

 

[The Rev]

the DriveExists line is highlighted with the "Object doesn't support this property or method" error. I have Access on another PC and I put this code into a blank DB and it worked there. Just not on my laptop.

 

[The Rev]

So somehow, a non-ASCII character got in my string for the drive letter. I deleted the line and retyped it and it now works. That was just strange...

 

[theDBguy]

So somehow, a non-ASCII character got in my string for the drive letter. I deleted the line and retyped it and it now works. That was just strange...

Glad to hear you got it sorted out. Cheers!

 

[Gasman]

I wouldn't have thought you would have spaces in there either?