MS Access Database with External Data - Opening folder in Explorer from Access

Author

Opening folder in Explorer from Access

Luc

2006-04-05, 11:37 am

I open an explorer window on a particular folder from access (using Shell
command or FollowHyperlink). I possibly need to rename the folder. My
problem is that Windows apparently prevents renaming the folder as it
appears to be locked or dependent from Access. Any suggestions as to how to
overcome this problem ?
Thanks in advance.
Luc

John Nurick

2006-04-05, 8:28 pm

I don't have any problem renaming a folder that has been opened using
(e.g.)

Shell "explorer.exe ""C:\temp\folder\"""
or
Application.FollowHyperlink "C:\temp\folder"

But if a file in that folder is open (whether by Access or some other
process) you won't be able to move or rename the folder.

On Wed, 5 Apr 2006 12:04:03 -0400, Luc <mail@morinip.com> wrote:

>I open an explorer window on a particular folder from access (using Shell
>command or FollowHyperlink). I possibly need to rename the folder. My
>problem is that Windows apparently prevents renaming the folder as it
>appears to be locked or dependent from Access. Any suggestions as to how to
>overcome this problem ?
>Thanks in advance.
>Luc

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Sponsored Links