ACC95: Error Exporting MS Access 95 Table to Version 2.0

Last reviewed: May 7, 1997
Article ID: Q145771
The information in this article applies to:
  • Microsoft Access version 7.0

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

If you try to export a Microsoft Access version 7.0 table to a Microsoft Access version 2.0 database, you may receive the following error message:

   Invalid field data type.

CAUSE

The Microsoft Access 7.0 table contains a field with a ReplicaID field size. The ReplicaID field size is a Globally Unique Identifier (GUID), 16 bytes long. Microsoft Access version 2.0 does not support the ReplicaID field size. Although Microsoft Access version 7.0 will convert a field with a ReplicaID field size to the Text data type when it exports the table to a file format like text-delimited or dBASE, it will not convert the field's data type if the export is to a version 2.0 database.

RESOLUTION

If you want to export a version 7.0 table that contains a field with a ReplicaID field size to a version 2.0 database, do one of the following:

  Create a select query containing all fields except the field with a
  Replica ID field size, and then export the query.

  -or-

  Export the table to another file format, such as text-delimited or dBASE,
  and then import the file into the version 2.0 database.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Start Microsoft Access 7.0.

  2. Create the following new table and called it Table1:

          Table: Table1
          -----------------------------------
          Field Name: ID
    
             Data Type : AutoNumber or Number
             Field Size: Replication ID
          Field Name: FName
             Data Type : Text
    
    

  3. Save and close the Table1 table without defining a primary key.

  4. On the File menu, click Save As/Export.

  5. In the Save As dialog box, click "To an external File or Database," and then click OK.

  6. In the Save Table 'Table1' dialog box, click Save Microsoft Access (*.mdb, *.mdw, *.mda) in the Save As Type box, locate a version 2.0 database, and then click Export.

  7. In the Export dialog box, click OK. Note that you receive the following error message:

          Invalid field data type.
    

NOTE: Step 2 in the example is just one method of creating a field with a ReplicaID field size. If a table is in a replicated database and the table is replicable, it automatically contains a field named s_Guid. This field has a ReplicaID field size, and cannot be deleted.

REFERENCES

For more information about field size, search for "field size," and then "FieldSize Property" using the Microsoft Access for Windows 95 Help Index.


Keywords : GnlOthr kberrmsg kbusage
Version : 7.0
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : Info_Provided


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 7, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.