Ideally, your document has a field that exposes a connection to the BDC and then tries to autopopulate other fields based on that connection. In the Sharepoint 'Properties' page, these autopoulated fields are editable. However, in the Word2007 client, these fileds are grayed out, waiting for data from the BDC. You cannot edit these fields. This becomes problematice if the Primary Key field for the BDC metadata is required. The Word2007 client interprets not only the main field as required, but all the fields that this connector autopopulates. What if your database record for this primary key is not fully filled out? What if its missing one piece of data? That data cannot be autopoulated into the metadata field (which is implicitly required in Word2007). As a result, when you try to save and check in the document, Word throws an error saying that the required meatdata is not filled out. You are stuck! You can't leave any field blank, but you also can't fill them out due to the fact that they're autopopulated.
At this point you have one of 4 options:
- Uncheck the 'Required' property for the Primary Key BDC metadata
- Upload, but don't check in the document. Then go into the Sharepoint GUI, fill out the required properties, and check in.
- Check in the document using Word 2003 or earlier.
- Fill out all the data for that BDC record in the source database.