Results 1 to 3 of 3
  1. #1
    dlreich is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    2

    Mail merge using encrypted Access db unable to provide password

    I have set up a Word 2010 mail merge document (.docx) that gets its data from an Access 2010 (.accdb) table. It works fine when the Access database is not encrypted. When the db is encrypted, the mail merge fails with the message "Error has occurred: Not a valid password." Is it possible for this procedure to work with an encrypted Access db? If so, how do I make it work?



    Thanks for any suggestions.

    David

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    By encrypted do you mean it is an accde file or just password protected? Here is one discussion on mail merge with password protected db http://boardreader.com/thread/Protec...3hwX5cr6h.html. The last post says it all.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    dlreich is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    2

    Thanks for the reply

    Quote Originally Posted by June7 View Post
    By encrypted do you mean it is an accde file or just password protected? Here is one discussion on mail merge with password protected db http://boardreader.com/thread/Protec...3hwX5cr6h.html. The last post says it all.
    I meant password protected. Thanks for the link. I guess I'll have to try that workaround or some other.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Mail Merge from Access Query
    By Baldeagle in forum Reports
    Replies: 5
    Last Post: 03-17-2012, 06:43 PM
  2. Mail merge from from Access to Word
    By williamgladstone in forum Access
    Replies: 1
    Last Post: 03-22-2011, 12:00 PM
  3. Mail Merge with Access
    By missesclick in forum Access
    Replies: 6
    Last Post: 12-09-2010, 01:28 PM
  4. Access Password - Not encrypted
    By shexe in forum Access
    Replies: 5
    Last Post: 09-29-2010, 02:15 PM
  5. Mail merge from two access tables
    By Peter in forum Access
    Replies: 2
    Last Post: 08-24-2010, 12:17 PM

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