Special Edition Using Microsoft Office Access 2003

Changing the Publishing Point of an InfoPath Template

When I try to open a TemplateName.xsn file, I receive an "InfoPath cannot create a new, blank form" message because the publishing location has changed.

Publishing an InfoPath template generates a reference to the folder in which you saved the TemplateName.xsn file. When you publish a template and then copy or move the file, you can't create a form from the relocated or copied template. To solve this problem, right-click the TemplateName.xsn file and choose Design to open the file in InfoPath design mode. Choose File, Save As and overwrite the existing TemplateName.xsn file. Alternatively, publish the form to the new location. In either case, XML data files you copy to the new location open in the original template, not the template in the new location. If the original template is missing, you can't open the copied data files.

Table Column Name Conflicts with WSS Lists

When I try to export an Access or SQL Server table to a WSS list, I receive an error message, the list is missing some of the table columns, or both

WSS lists have several internal columns for list management that don't appear in datasheet or standard view. Figure 26.48 shows these columns: ID, Title, Modified, Created, Created By, Modified By, Attachments, and Edit. Tables having columns with any of these names cause problems during the export process. You must rename conflicting table columns or substitute a query with column name aliases to export the table data successfully.