vb with word - very urgent

[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.

 

[Jamie Collins]

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.

Are you using a workgroup e.g. something like:

Set wk1 = DBEngine.CreateWorkspace("MyWorkspace", "MyID", "mypassword")
Set db1 = wk1.OpenDatabase(DB_PATH, False, False)

Jamie.

--