ACC2: "Unexpected Error from External Database Driver [7]"

ID: Q116383


The information in this article applies to:
  • Microsoft Access 2.0


SYMPTOMS

Advanced: Requires expert coding, interoperability, and multiuser skills.

When you are working with an attached Btrieve table, you may receive the following error message:

Unexpected error from external database driver [7]
-or-

A query based on an attached Btrieve table does not return any records in Microsoft Access version 2.0. This same query does return records correctly in Microsoft Access version 1.x.


CAUSE

These problems are caused by an error in the Btrv200.dll Btrieve ISAM driver that is installed by Microsoft Access 2.0.


RESOLUTION

An updated Btrieve ISAM driver is available in the Microsoft Download Center. This driver is for use by registered owners of Microsoft Access version 2.0 and Microsoft Visual Basic version 3.0 for Windows - Professional Edition only. By downloading this driver, you are indicating that you are a registered owner of one of these products. For downloading instructions, please see the "INSTRUCTIONS FOR DOWNLOADING" section later in this article.


STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 2.0. This problem no longer occurs with the Microsoft Jet database engine version 2.5, which is available with the Microsoft Access version 2.0 Service Pack. For information about how to obtain the Service Pack, please see the following article in the Microsoft Knowledge Base:

Q122927 WX1124: Microsoft Access Version 2.0 Service Pack


MORE INFORMATION

You can differentiate between the original and updated drivers by checking the file sizes. The original Btrv200.dll file has a file size of 110,592 bytes. The updated file has a file size of 110,624 bytes. For a network installation of Microsoft Access, install the updated file in the Access\System directory. For a stand-alone installation of Microsoft Access, install the updated file in the Windows\System directory.

NOTE: Do not install the updated file before installing Microsoft Access. You should install Microsoft Access first, and then install the updated driver.

How to Install the Updated Driver After Downloading

Stand-Alone Installation:
  1. Make a backup copy of the original Btrv200.dll file by renaming it, or by copying it to another location. The Btrv200.dll file is in the Windows\System directory.


  2. Copy the updated Btrv200.dll file to the Windows\System directory.


Network Installation:
  1. The network administrator should make a backup copy of the original Btrv200.dll file by renaming it, or by copying it to another location. The Btrv200.dll file is in the Access\System directory on the network server.


  2. The network administrator should copy the updated Btrv200.dll file to the Access\System directory on the network server.


  3. The network administrator should make a backup copy of the Setup.inf file by renaming it, or by copying it to another location. The Setup.inf file is located in the Access installation directory on the network server.


  4. The network administrator should open the Setup.inf file in any text editor (such as Notepad), and change the line that reads
    
         "DLL"= 1,SYSTEM\BTRV200.DLL,,,,,,1033,,,,,,,SHARED,110592,,,,2.0.0.13, 
    to read:


  5. 
         "DLL"= 1,SYSTEM\BTRV200.DLL,,,,,,1033,,,,,,,SHARED,110592,,,,2.0.0.15, 
  6. After making this change, the network administrator should save and then close the Setup.inf file.

    This modification changes the internal version from 2.0.0.13 to 2.0.0.15. Changing the internal version number in the Setup.inf file will cause future workstation installations of Microsoft Access to install the updated Btrieve driver on workstations that have a copy of the original Btrieve driver.


  7. The network administrator should make the updated Btrv200.dll file available to those who have installed Microsoft Access to their local workstation hard disks. These users should copy the updated file to their Windows\System directories.


INSTRUCTIONS FOR DOWNLOADING

The following file is available for download from the Microsoft Download Center. Click the file name below to download the file:
Btr200.exe
For more information about how to download files from the Microsoft Download Center, please visit the Download Center at the following Web address
http://www.microsoft.com/downloads/search.asp
and then click How to use the Microsoft Download Center.

Btrieve is manufactured by Pervasive Software, a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.

Additional query words:

Keywords : kb3rdparty kberrmsg kbfile Softlib
Version : WINDOWS:2.0
Platform : WINDOWS
Issue type : kbbug


Last Reviewed: November 5, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.