The information in this article applies to:
SYMPTOMS
When you try to attach a Btrieve table in Microsoft Access, you receive the
following error message:
CAUSEWhen Microsoft Access attaches a Btrieve table, it compares information in the Xtrieve dictionary file (FILE.DDF) with information in the TBLNAME.DAT file. The most common reasons for the above error message are differences in index information. RESOLUTIONRedefine the Btrieve index so that it is exactly the same length as the field it indexes. STATUSThis problem does not occur in Microsoft Access version 1.1. MORE INFORMATION
In the Btrieve file format, the length of the index may not match the
length of the field. This is a valid condition. The Xtrieve dictionary
file (FILE.DDF) ignores these indexes, but Microsoft Access interprets
them as invalid and returns the above error message.
Example 1The TBLNAME.DAT file is defined with the following three columns:
Index1 is defined with a length of 20 characters, the combined length of the Firstname and Lastname fields. Resolution: Redefine the Btrieve index into one multiple-segment index, giving each segment a defined length of 10 characters. Example 2The TBLNAME.DAT file is defined with the following three columns:
Index2 is defined with a length of four characters, shorter than the defined length of the Firstname field. Resolution: Redefine the Btrieve index on Firstname. Give it a 10-character length, matching the size of the Firstname field. Example 3The TBLNAME.DAT file is defined with the following three columns:
Index3 is defined with a length of 12 characters, slightly longer than the defined length of the Firstname field. Resolution: Redefine the Btrieve index on Firstname. Give it a 10-character length, matching the size of the Firstname field. Example 4The TBLNAME.DAT file is defined with the following two columns:
Index4 is defined on a numeric byte range index. There is no index defined on any field in the table. Resolution: Remove the numeric byte range index completely, then redefine the index on an existing field. Be sure that the length of the index matches the length of the indexed field. Btrieve and Xtrieve are manufactured by Pervasive Software, a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability.
Keywords : kb3rdparty kberrmsg IsmBtrv |
Last Reviewed: March 13, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |