 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
VB Forum / COM / October 2004Word Mail Merge Automation
im using VB6 my word document has an MS Access mdb as the datasource, its password protected.. i've tried passing the password to the PasswordDocument property of the OpenDataSource method, but access still prompts me for a password.. anyone know how to stop access from prompting me?? What was wrong with the answer you got last time? > im using VB6 > > my word document has an MS Access mdb as the datasource, its password > protected.. i've tried passing the password to the PasswordDocument property > of the OpenDataSource method, but access still prompts me for a password.. > anyone know how to stop access from prompting me?? i dnt want users to be typing in the database password when Access prompts them. its needs to be automated... > im using VB6 > > my word document has an MS Access mdb as the datasource, its password > protected.. i've tried passing the password to the PasswordDocument property > of the OpenDataSource method, but access still prompts me for a password.. > anyone know how to stop access from prompting me?? > i dnt want users to be typing in the database password when Access prompts > them. its needs to be automated... Try changing... PasswordDocument:="myPassword", to Password=myPassword, or Password="myPassword", fwiw, I used the ADO data control's connection string wizard to build a connection string that opens a password protected access db. Try the wizard.  SignatureKen Halter - MS-MVP-VB - http://www.vbsight.com Please keep all discussions in the groups.. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.