opendatasource - avoid password prompt

[darren via OfficeKB.com]

Hi

Pulling my hair out. I have an ACC2003 mde which has basic password
protection (not mdw). It opens a merge document (Word2003) and sets
datasource using opendatasource. However, it prompts the users for a password.
I have tried to include the password but the prompt still appears. All help
appreciated.

strConnection = "DSN=MS Access Database;DBQ=" & CurrentProject.FullName & "
;FIL=MS Access'UID=Admin;PWD=test;"

' Set the mail merge data source
objWord.MailMerge.OpenDataSource _
Name:=CurrentProject.FullName, _
LinkToSource:=True, _
Connection:=strConnection, _
ReadOnly:=True, _
SQLStatement:="SELECT * FROM [" & strTbl & "]"

Thanks

Darren

 

[darren via OfficeKB.com]

Think I've sussed it. I tried setting it manually then looking at
connectstring but still did not work. However, when I tried doing exactly the
same thing but recording it as a macro I got a different result.

Solution:

Name:="", _

 

[Sudha]

Hi

So unless one uses macros you can't mailmerge using a password protected mdb?