Re: [MS_AccessPros] Opening folder

 

Hi Kevin,

adding on since I don't know how you are using these folders ...

I normally hang folders off the back-end directory for shared images and shared files. I also have an interface to move/copy and then rename files they want to include -- but VBA does it all, they do not need to browse themselves except to identify the source files in the windows dialog box.  This is a convenient way to keep external files as files and move/point to the back-end and everything it needs to reference.  I have code to get that BE directory for each user and then tack on whatever subfolder may be needed such as \images. Users also need permissions for the back-end subdirectories too.

respectfully,
crystal

http://www.MsAccessGurus.com
connect to me, let's build it together
 
~ have an awesome day ~

On 5/18/2017 7:23 AM, qing qing qingqinga@yahoo.com [MS_Access_Professionals] wrote:

John-

I got it. I think I'd better not to enable the accessibility to the backend folder. Thanks a lot.

Best Regards,

Kevin

Kevin Zhao

On Thu, May 18, 2017 at 7:52 PM +0800, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

 

Kevin-

So, you open the folder for them, and then what do you expect them to do?  Unless you use Windows security, you can't prevent them from going to other folders.

John Viescas, Author

Effective SQL

SQL Queries for Mere Mortals 

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

http://www.viescas.com/ 

(Paris, France)

On May 18, 2017, at 1:25 PM, qing qing qingqinga@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John-

I want the users to store relevant docs in the same folder where the backend locats. You know there might be several users handling the same tour group. They can get access to same folder.

Best Regards,

Kevin

Kevin Zhao

On Thu, May 18, 2017 at 6:40 PM +0800, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

Kevin-

No, you can't prevent them.  Why are you opening a folder?  What is it you want the user to do or see?

John Viescas, Author

Effective SQL

SQL Queries for Mere Mortals 

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

http://www.viescas.com/ 

(Paris, France)

On May 18, 2017, at 12:10 PM, qing qing qingqinga@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Dear All,

I use the following code to open up a folder. My question is how to prevent users from browsing directories out of this folder? Thanks.

Shell "C:\WINDOWS\explorer.exe"""" & strPath & strfolder & "", vbNormalFocus

Thanks,

Kevin

Kevin Zhao

__._,_.___

---

Posted by: crystal 8 <strive4peace2008@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (6)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___