ACC95: Error Exporting Microsoft Access 95 Table to Version 2.0 (145771)
The information in this article applies to:
- Microsoft Access for Windows 95 7.0
This article was previously published under Q145771
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
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.
REFERENCES
For more information about field size, search for "field size," and then
"FieldSize Property" using the Microsoft Access for Windows 95 Help Index.
Modification Type: | Major | Last Reviewed: | 7/5/2002 |
---|
Keywords: | kberrmsg kbprb kbusage KB145771 |
---|
|