Word Mail Merge Automation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jas - 27 Oct 2004 10:34 GMT

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??

Reply to this Message

Hugh Janus - 27 Oct 2004 11:07 GMT

Can you post your source code?

> Im using VB6 to automate.
>
[quoted text clipped - 5 lines]
>
> anyone know how to stop access from prompting me??

Reply to this Message

Dixie Normous - 27 Oct 2004 11:14 GMT

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!!

> Im using VB6 to automate.
>
[quoted text clipped - 5 lines]
>
> anyone know how to stop access from prompting me??

Reply to this Message

Dixie Normous - 27 Oct 2004 11:28 GMT

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

> hi Jas,
>
[quoted text clipped - 19 lines]
>>
>> anyone know how to stop access from prompting me??

Reply to this Message

Cindy M -WordMVP- - 31 Oct 2004 11:05 GMT

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 :-)

Reply to this Message

jas - 01 Nov 2004 16:00 GMT

hi,

Password on the database

> Hi Jas,
>
[quoted text clipped - 17 lines]
> This reply is posted in the Newsgroup; please post any follow question or
> reply in the newsgroup and not by e-mail :-)

Reply to this Message

Cindy M -WordMVP- - 02 Nov 2004 10:55 GMT

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

:-)

Reply to this Message