"sympatico" wrote ...

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.

--