VB with Word

[sympatico]

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...
Thanks in advance for your help.
I'm in very urgent for that.

 

[Gary Labowitz]

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...
Thanks in advance for your help.
I'm in very urgent for that.

If I remember this right, the user id and password can be passed in the
connection string, which is the parameter to open that specifies the mdb
name. The string is something like
"DSN=path-and-name;UID=user-id;PWD=password;"
I think if provided this way Access will not prompt for password.