ACC: "Unexpected Error from External Database Driver [22]"

• Microsoft Access versions 1.1, 2.0

SYMPTOMS

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

When you try to open an attached Btrieve table, you receive the following error message:

  Unexpected error from external database driver [22]

CAUSE

Btrieve returns this error message when there is a mismatch between the FIELD.DDF file and the Btrieve data table. This problem usually occurs when the internal structure of the Btrieve table has been changed without corresponding changes having been made to the FIELD.DDF file. The Xtrieve manual lists this error with the following description:

   22  Data buffer length too short
       The data buffer parameter is not long enough to accommodate the
       length of the data record defined when the file was created.
       Verify that the length of the data buffer is at least as long
       as the file's defined record length.

RESOLUTION

Make sure that the internal structural definition of the Btrieve table is the same as the FIELD.DDF file. This can be done using Novell's Xtrieve program or a third-party DDF builder to update the FIELD.DDF file.

MORE INFORMATION

The third-party products discussed here are manufactured by vendors independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability.

REFERENCES