Hi: Using VB6, Access2000, Word2000

I trying to do a mailmerge using VB6 & Word2000 with an Access2000
password protected database. I don't know how to provide the password
to the string.

Normally when accesing the db I connect as follows:

VB Code:
  1. 'adoConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
  2. '" Data Source=\\BigDaddy\Datalib\MegaOne.mdb; Persist Security Info=False; Jet OLEDB:Database Password=DogDayAfternoon23x "

I tried the above code but got errors


The following is what I'm currently using, but it prompts me to
enter the password, which I do not want to happen once itgets into production.

VB Code:
  1. ' Set the mail merge data source as the MegaOne.mdb database.
  2. objWord.MailMerge.OpenDataSource _
  3. Name:="\\BigDaddy\Datalib\MegaOne.mdb", _
  4. LinkToSource:=True, _
  5. Connection:="TABLE Customers", _
  6. SQLStatement:=" SELECT " & _
  7. " CustAuthorizedFirstName, CustAuthorizedLastName," & _
  8. " CustDepartment, CustCompanyName, " & _
  9. " CustAddress1, CustAddress2, " & _
  10. " CustCity, CustState, CustZipcode, " & _
  11. " CustBalance " & _
  12. " FROM " & _
  13. " [Customers]" & _
  14. " Where " & _
  15. " CustBalance > 0 "

The second problem I'm having here is that the document is set with a font size of 12 but when prints, the first word of the merged fields are printed with a font size of 10 instead of the original document which as I stated is set for 12.

Can someone shed some light?

Thanks