Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-21-2011, 10:02 AM
dbaldwin dbaldwin is offline Access password blocking Word mail merge Windows Vista Access password blocking Word mail merge Office 2007
Novice
Access password blocking Word mail merge
 
Join Date: Apr 2011
Posts: 2
dbaldwin is on a distinguished road
Default Access password blocking Word mail merge

I would like to mail merge a Word 2007 document with data from a query in Access 2007. However, I have password protected the database and the mail merge wizard can't handle it. Is ther a work around shot of disabling the password protection?



Thank you in advance for any assistance.
Reply With Quote
  #2  
Old 04-21-2011, 01:47 PM
macropod's Avatar
macropod macropod is offline Access password blocking Word mail merge Windows 7 32bit Access password blocking Word mail merge Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Cross-posted at: http://answers.microsoft.com/en-us/o...c-68b599b31bf5

For cross-posting etiquette, please see: http://www.excelguru.ca/node/7

For a possible solution, see: http://www.tech-archive.net/Archive/.../msg00180.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 04-22-2011, 06:31 AM
dbaldwin dbaldwin is offline Access password blocking Word mail merge Windows Vista Access password blocking Word mail merge Office 2007
Novice
Access password blocking Word mail merge
 
Join Date: Apr 2011
Posts: 2
dbaldwin is on a distinguished road
Default Sorry about the cross posting

Sorry about the cross posting. I was unaware, very new at this. Your etiquette article was very informative, and made a great deal of sense. The few times I've posted I have sometime cross posted, and didn't realize the interconnected nature of the great individuals who are volunteering. The responses have been very helpful. I went to the possible solution you recommended, and the Data Link Properties seemed to be looking for a server workgroup, or user name and password to log onto a server. I'm alrady logged onto a Novel server. In an effort to test, I copied the database to my desktop, but got the same errors. The issue seems to be just the password protection on the database. I tried another db without a password and connected right away. Any other thoughts? Again I do appreciate the etiquette education and your efforts to assist me.
Reply With Quote
  #4  
Old 04-22-2011, 02:50 PM
macropod's Avatar
macropod macropod is offline Access password blocking Word mail merge Windows 7 32bit Access password blocking Word mail merge Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You might want to try the approach suggested in this article: http://support.microsoft.com/kb/208933. Although it's for Access, the principles should be the same for other databases too.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access password blocking Word mail merge Combine Records when Mail Merge from Access Tom Pickles Misc 2 08-24-2010 06:00 PM
mail merge from access query or two tables peter Mail Merge 0 08-24-2010 05:32 PM
Mail Merge--different connections of Access in Single Word File. Goldenbird Mail Merge 3 06-12-2009 06:42 AM
Word / Access - Mail Merge ibuilders Mail Merge 0 07-30-2007 06:18 PM
Access password blocking Word mail merge Access 2003 query with wildcards into Word 2003 mail merge Poingdexter Office 1 10-30-2005 06:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:47 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft