ACC95: TransferText Method or Macro Action May Cause ErrorLast reviewed: May 14, 1997Article ID: Q155513 |
The information in this article applies to:
SYMPTOMSModerate: Requires basic macro, coding, and interoperability skills. When you export a table using either the TransferText action in a macro or the DoCmd.TransferText method in a Visual Basic for Applications procedure, you may receive the following error message:
INSERT INTO statement contains unknown field name <field name>. (Error 3127) CAUSEThe conditions that cause this error vary depending on the structure of the table you are exporting. The error is related to the number of fields in the table and their data types, in particular the number of Text fields in the table.
RESOLUTIONThere are two methods to work around the problem:
STATUSMicrosoft has confirmed this to be a problem in Microsoft Access 7.0. This problem no longer occurs in Microsoft Access 97.
MORE INFORMATIONThe error occurs when you run Microsoft Access 7.0 with Microsoft Windows 95. It does not occur with Microsoft Windows NT Server 3.51 or Microsoft Windows NT Server 4.0. Not all tables cause the error.
Steps to Reproduce ProblemUsing the TransferText Action in a Macro:
REFERENCESFor more information about the TransferText macro action, search for "TransferText action," and then "TransferText Action" using the Microsoft Access 7.0 Help Index. For more information about the TransferText method, search for "TransferText method" using the Microsoft Access 7.0 Help Index. |
Keywords : IsmTxtd kb3rdparty kberrmsg
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |