vb with word - very urgent

  • Thread starter Thread starter sympatico
  • Start date Start date
S

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.
 
sympatico said:
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.
Click to expand...

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.

--
 
Back
Top