Re: [MS_AccessPros] Opening folder

 

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: qing qing <qingqinga@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

---

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

.

__,_._,___