Page 2 of 2 FirstFirst 12
Results 16 to 22 of 22
  1. #16
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    In order for that CDO example to work the SMTP relay has to accept password authentication. An exchange host is not likely to work. However, you could use another email account. Having said that, Gmail and other free email hosting will not allow this code to work.



    What you could do is edit each of the client's registry to trust Networks and trust the folder where the BE resides. Then, automate outlook as Hidden, using code like this.
    https://www.accessforums.net/import-...tml#post281258

  2. #17
    nick404's Avatar
    nick404 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    May 2015
    Location
    Wisconsin
    Posts
    352
    Okay I will dig into this more on my own. Thanks for all the help guys!

  3. #18
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Albright, I have a sample DB floating around here somewhere that will add folders as a trusted location. Let us know ...

  4. #19
    nick404's Avatar
    nick404 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    May 2015
    Location
    Wisconsin
    Posts
    352
    If you happen to find it I would really appreciate taking a look at it!

  5. #20
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    This is an old upload that I have linked here. IIRC, there is a need to add the trailing back-slash to the end of the path when using the "include subfolders" option.

    When you desire to include subfolders tick the option and
    ServerName\Folder\Folder\

    If you just want that folder
    ServerName\Folder\Folder
    Attached Files Attached Files

  6. #21
    nick404's Avatar
    nick404 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    May 2015
    Location
    Wisconsin
    Posts
    352
    So by utilizing this form you have here, and trusting the folder where my be resides, what exactly does this ensure?

    Does it ensure I can successfully use the code you posted?

  7. #22
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Quote Originally Posted by nick404 View Post
    ...Does it ensure I can successfully use the code you posted?
    The sample DB is for adding the folder where a DB resides as a trusted location. This is done by editing the registry of the client machine. When you launch an access file, it will not open in edit mode and ask the user if they want to trust the file. The user can enable editing and their registry is edited for that file. The next time the file is launched from that same location, there is no warning and the file is able to be edited by the user. If the user does not have a full version of Access and is using the free Run Time download, they do not get the option of adding the file to their trusted location. Users of the free RT download will be prompted by a security warning each time they open the file.

    The only thing the sample DB does is add the "Entire Folder" or the "Entire Folder and Subfolders" as a trusted location, regardless of the client using the full version of Access or the free RT.

    Whether or not adding the Registry Key will have any affect on the Outlook Warning, I do not know. For sure, changing the Global Options on each client machine (within Access) will do the trick. This is what June7 described earlier. What I know, also for sure, is that I have added certain folders as trusted and the Outlook Automation code I linked to did not throw any warnings when I ran it from such a location.

    It may be a fact that the DoCmd vs. the Automation code I provided is the only difference between the warning from Outlook and no warning from Outlook.

    I have not taken the time to check it out because all of my apps automatically check for the Registry Key.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. button to link to specific backend file
    By quicova in forum Import/Export Data
    Replies: 5
    Last Post: 11-04-2013, 01:39 PM
  2. Replies: 7
    Last Post: 08-28-2013, 02:30 AM
  3. break the link to a backend table
    By markjkubicki in forum Programming
    Replies: 1
    Last Post: 06-28-2013, 10:49 PM
  4. Replies: 2
    Last Post: 05-21-2013, 02:25 PM
  5. Replies: 5
    Last Post: 11-13-2012, 12:16 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums