Dir() and \\machine_name = Error 52 1

[maxhugen]

I'm trying to do ...

s = Dir("\\machine_name\myFolder\")

... but I'm getting err 52. Does anyone know if Access supports running Dir() on a path other than a mapped drive?

Or am I trying this the wrong way?

MTIA

Max Hugen
Australia

 

[PHV]

You can't use an UNC with the Dir function but you may play with FileSystemObject:

http://msdn.microsoft.com/en-us/library/bkx696eh(VS.85).aspx

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[maxhugen]

Thanks PHV, I'll give the FSO a try.

Max Hugen
Australia

 

[maxhugen]

PHV, after trying a few options, including kernel32.dll, I finally found that UNCs actually DO work with Dir()!

It seems that it will work provided the UNC is Shared. Also, a trailing backslash must be used. eg

Dir("\\he-data") - Fails, err 52
Dir("\\he-data\") - Fails, err 52
Dir("\\he-data\hugen data") - Fails, err 52
Dir("\\he-data\hugen data\") - Succeeds

('hugen data' is a shared folder on \\he-data)

Max Hugen
Australia

 

[PHV]

Thanks for the info.