Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
HELP! Automate Mail merge using ODBC into a Secure Access Database
After securing my Access 97 database, and
established user-level password and access permissions, I started getting the
error message "Word could not open the data source" every time I try to run mail
merges. I have entered UID:= and PWD:= portions of the connection string, and researched every article and
information site that I can find. Is there another way to establish that data source
connection in Word 97 for the Mail Merge? HELP!
One of my reference books (VB4) speaks to the issue of the Jet engine
not being able to open password protected files. Is that the problem?
Can I bypass the Jet engine & still execute the mail merge command from Access?
Due to formatting and saving issues, recreating the documents as reports is
not an option.
Connection string is:
constr = "DSN=MS Access 97 Database;UID=****;PWD=****;DBQ=C:My Documentsdbs.mdb;FIL=RedISAM;"
Mail merge command line I am using is:
mailmerge.OpenDataSource Name:="C:My Documentsdbs.mdb", ReadOnly:=False, LinkToSource:=True, _
Connection:=constr, SqlStatement:="Select * from [" & qry & "]"