File picker wont let go...

[NauticalGent]

Good morning everyone, I'm having an issue with the msoFileDialogFilePicker that I have not seen anyone ask about...

It works as advertised but when I try to copy the file form its original location to another location, I got runtime error 70 - Permission denied. While reading up on the msoFileDialog family, there was a footnote about if the file is open, the Permission Denied error is what you get.

I am using the FileCopy method to attempt this and I have tried setting the FileDialog object to nothing before the FileCopy and I have even tried passing the SelectedItems(1) (strFilePath = .SelectedItems(1)) to another Sub in hopes that it would somehow "let go"...nothing has worked.

Is there something I am missing or is the nature of the beast? If so, what is the work-around?

 

[theDBguy]

Hi. I believe there is a bug right now when using the FileDialog object. The folder gets locked up until Access is closed. Are you using the latest version of Access?

PS. On second thought, it may be a bug in Office, since the FileDialog is a common object to the entire Office suite.

 

[NauticalGent]

Hi. I believe there is a bug right now when using the FileDialog object. The folder gets locked up until Access is closed. Are you using the latest version of Access?

PS. On second thought, it may be a bug in Office, since the FileDialog is a common object to the entire Office suite.

Thanks DBG, I did notice that once I closed Access, there was a "reset" of sorts. Guess I'll have to wait it out...

 

[theDBguy]

Okay, here's a possible workaround. Try using ChDir to change the current directory to a different folder.

 

[NauticalGent]

Are you using the latest version of Access?

MSO 2301 16.0.16026.2016 64-bit

 

[NauticalGent]

Okay, here's a possible workaround. Try using ChDir to change the current directory to a different folder.

There are two types of cool in this world: DBG Cool and those that SHOULD be DBG cool...worked like a charm, you sir, are the shiznit.

 

[theDBguy]

There are two types of cool in this world: DBG Cool and those that SHOULD be DBG cool...worked like a charm, you sir, are the shiznit.

Glad to hear you got it to work. I can't take all the credit. I just passed along the information from those who know more than I do. Cheers to them and you!

 

[NauticalGent]

It seems this issue made for a good topic @NoLongerSet:

Microsoft Access's Surprising Folder Locking Behavior (nolongerset.com)