ACC95: Error Exporting MS Access 95 Table to Version 2.0ID: Q145771
|
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.
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.
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.
This behavior is by design.
Table: Table1
-----------------------------------
Field Name: ID
Data Type : AutoNumber or Number
Field Size: Replication ID
Field Name: FName
Data Type : Text
Invalid field data type.
For more information about field size, search for "field size," and then "FieldSize Property" using the Microsoft Access for Windows 95 Help Index.
Keywords : kberrmsg kbusage GnlOthr
Version : 7.0
Platform : WINDOWS
Issue type : kbprb
Last Reviewed: April 30, 1999