Word Mail Merge Automation

[jas]

Im using VB6 to automate.

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 MS Access still prompts me for a
password..

anyone know how to stop access from prompting me??

 

[Hugh Janus]

Can you post your source code?

 

[Dixie Normous]

hi Jas,

i don't know why your using VB6 and MSAccess - you must be some kind of
caveman!

anyhow try setting the PasswordDocument property of the OpenDataSource
method - that works for me.

good luck

Dixie

P.S. Reply if you get any problems!!

 

[Dixie Normous]

Jas,

onreflection I don't think I answered your question too well.

try www.gotdotnet.com they have some really easy example that even a VB
devloper like you could follow.

Dixie

 

[Cindy M -WordMVP-]

Hi Jas,

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 MS Access still prompts me for a
password..

Password, as in password on the database, or with the full security with user
login?

Version of Word and Access? Have you tried linking to the data base through
the UI (like a user) and can you do it successfully? If yes, try recording the
steps in a macro to get the code you need.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[jas]

hi,

Password on the database

Hi Jas,

Password, as in password on the database, or with the full security with user
login?

Version of Word and Access? Have you tried linking to the data base through
the UI (like a user) and can you do it successfully? If yes, try recording the
steps in a macro to get the code you need.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)


This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[Cindy M -WordMVP-]

Hi Jas,

Password on the database

Right. And now I need to know the version of Word you're
using.

FWIW, I can get it to work with an ODBC connection, but it
sounds as if you're trying to use DDE. And in order to
discuss how to get the OpenDataSource syntax for ODBC, I
need to know the version of the software you're trying to
automate.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail