Article ID: 116383
Article Last Modified on 8/5/2004
APPLIES TO
- Microsoft Access 2.0 Standard Edition
This article was previously published under Q116383
Advanced: Requires expert coding, interoperability, and multiuser skills.
SYMPTOMS
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.
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:
122927 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:
- 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.
- Copy the updated Btrv200.dll file to the Windows\System directory.
Network Installation:
- 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.
- The network administrator should copy the updated Btrv200.dll file to the Access\System directory on the network server.
- 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.
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,- 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. - 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:
![[GRAPHIC: ]](/wiki/index.php?title=File:Download.gif){kind=small}
For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591 How to Obtain Microsoft Support Files from Online Services
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.
Additional query words: Btr200 exe
Keywords: kberrmsg kbdownload kbbug kbgraphxlinkcritical kbfile kb3rdparty KB116383
