Hi Kevin,
yes, here is one way -- look at how attachments are done for the free contact management template here:
Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments
http://www.msaccessgurus.com/Contacts.htm
to keep it simple, additional checking to weed duplicates is not done, but it could be. I also rename files but not sure I did that in the public version.
crystal
~ have an awesome day ~
Crystal-
Is there any example online?
Best Regards,
Kevin
Kevin Zhao
On Thu, May 18, 2017 at 11:08 PM +0800, "crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
you're welcome, Kevin
when browsing, if a user identifies same file that is already attached to another record, the file does not need to be copied again (use code to detect that). This is a big advantage to attaching information to each record in the database. An analysis of one database with a lot of attachments found that only 30% of the "attachment" files were unique when they were converted to external files again since it is common for more than one record to reference the same thing (not counting things like human photos). Aside from better performance, there can be less wasted space with duplicates with files as files. Also, external files are easier to render, especially when versions change.
respectfully,
crystal
http://www.MsAccessGurus.com
connect to me, let's build it together
~ have an awesome day ~
On 5/18/2017 9:36 AM, qing qing qingqinga@yahoo.com [MS_Access_Professionals] wrote:
Crystal-
Thanks a lot for your information.
Best Regards,
Kevin
Kevin Zhao
On Thu, May 18, 2017 at 10:11 PM +0800, "crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
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, AuthorEffective SQLSQL Queries for Mere MortalsMicrosoft Access 2010 Inside OutMicrosoft Access 2007 Inside OutMicrosoft Access 2003 Inside OutBuilding Microsoft Access Applications(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:
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, AuthorEffective SQLSQL Queries for Mere MortalsMicrosoft Access 2010 Inside OutMicrosoft Access 2007 Inside OutMicrosoft Access 2003 Inside OutBuilding Microsoft Access Applications(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 (10) |
Tidak ada komentar:
Posting Komentar