W
Warren Iwamoto
Everytime a database field is updated, the Select Data Source dialog pops up.
Here is the field definition (with the SQL removed):
DATABASE \c
"DSN=CATPSQSQLDSN;UID=thisthat;PWD=theother;WSID=localhost;DATABASE=PSQ_SQL;Network=DBMSSOCN" \s "SELECT ...
This works fine in Word 2000, sometimes gives an error in Word XP, and
always gives the Select dialog in Word 2003. The DSN is defined and works
properly from VBA in creating and executing an ADODB.Connection.
Anybody have any ideas on this? If at all possible, please reply directly to
"[email protected]". Thanks in advance.
Warren M. Iwamoto
Here is the field definition (with the SQL removed):
DATABASE \c
"DSN=CATPSQSQLDSN;UID=thisthat;PWD=theother;WSID=localhost;DATABASE=PSQ_SQL;Network=DBMSSOCN" \s "SELECT ...
This works fine in Word 2000, sometimes gives an error in Word XP, and
always gives the Select dialog in Word 2003. The DSN is defined and works
properly from VBA in creating and executing an ADODB.Connection.
Anybody have any ideas on this? If at all possible, please reply directly to
"[email protected]". Thanks in advance.
Warren M. Iwamoto