Select Data Source dialog comes up everytime I update a DATABASE f

[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
"(e-mail address removed)". Thanks in advance.

Warren M. Iwamoto

 

[Warren Iwamoto]

Just an update - I found the article (ID: 830870) about a very similar error.
The workaround identified there won't work for us because we need the field
embedded to allow for update if the database content changes.