'HELP! Automate Mail merge using ODBC into a Secure Access Database' Thread RSS Feed

HELP! Automate Mail merge using ODBC into a Secure Access Database

Thu, 10 Aug 2000 20:06:21 -0700

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 Documents\dbs.mdb;FIL=RedISAM;" 
Mail merge command line I am using is: 
mailmerge.OpenDataSource Name:="C:\My Documents\dbs.mdb", ReadOnly:=False, LinkToSource:=True, _ 
Connection:=constr, SqlStatement:="Select * from [" & qry & "]"

Re: HELP! Automate Mail merge using ODBC into a Secure Access Database

Fri, 12 Jan 2001 08:36:57 -0700

Have you tried manually creating the mail merge from within Word? How about using a DSN that contains the user information?? I have to do this to connect to Informix Database Engines and can do it using DSN connections.

Good luck.

Re: HELP! Automate Mail merge using ODBC into a Secure Access Database

Fri, 12 Jan 2001 08:40:23 -0700

RecordSet.open, adOpenDynamic

Wed, 08 May 2002 12:39:12 -0700

Hi, please help!
im working with Visual Basic 6.0 and Oracle,

i traing to open a Recorset
Dim Rec as New ADODB.Recordset
strSQL="SELECT * FROM Emp"
Rec.open strSQL, db, adOpenDynamic, adLockOptimistic

and Mi problem is:
Rec.cursortype change to adOpenStatic
i need to be open adOpenDynamic

my connection are:
dim db as New ADODB.Connection

db.Open "PROVIDER=OraOLEDB.Oracle;Data Source=dim0001;User id=usuario;Password=usuario;"

db.Open "PROVIDER=MSDAORA;Data Source=dim0001;User id=usuario;Password=usuario;"

db.Open "PROVIDER=MSDASQL;driver={Microsoft ODBC for Oracle};server=dim0001;uid=usuario;pwd=usuario;"

db.Open "driver={Microsoft ODBC for Oracle};server=dim0001;uid=usuario;pwd=usuario;"

db.Open "DSN=dim0001;uid=usuario;pwd=usuario"

db.Open "PROVIDER=MSDASQL;Data Source=dim0001;User id=usuario;Password=usuario;"

db.Open "Data Source=dim0001;User id=usuario;Password=usuario;"

db.Open "PROVIDER=MSDASQL;dsn=dim0001;uid=usuario;pwd=usua rio;"

i traing all but not work, please help!