When you are working with an attached Btrieve table, you may receive the following error message: -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.

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

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.

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:

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:

        "DLL"= 1,SYSTEM\BTRV200.DLL,,,,,,1033,,,,,,,SHARED,110592,,,,2.0.0.15,
   					

5. 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.
6. 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:
For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base: Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

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.