PSS ID Number: 322933
Article Last Modified on 5/13/2002
The information in this article applies to:
- Microsoft Access 2000
This article was previously published under Q322933
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access database (.mdb).
For a Microsoft Access 2002 version of this article, see 321003.
SYMPTOMS
When you try to import dBASE files into Access, you may receive the following error message:
CAUSE
This behavior may occur if the Borland folder exists on your computer and either of the following conditions is true:
- The Borland Database Engine (BDE) was previously installed on your computer but was later removed, leaving an empty folder.
-or-
- The BDE was installed incorrectly.
RESOLUTION
To resolve this issue, you can either reinstall BDE or use the following steps to remove it:
- Start Windows Explorer, and then browse to the Borland folder.
If you cannot locate the folder, follow these steps.NOTE: Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.
- Click Start, and then click Search.
- Click All files and folders.
- In the All or part of the file name box, type Borland.
- In the Look in list, click My Computer.
- Click Search.
- Rename the Borland folder as BorlandOld. (For example, rename C:\Borland as C:\BorlandOld.)
- Import the dBASE files again.
MORE INFORMATION
If you remove or rename the Borland folder, Access uses its own indexed sequential access method (ISAM) driver to import dBASE data.
The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
REFERENCES
For additional information about how to use dBASE data with Access, click the article numbers below to view the articles in the Microsoft Knowledge Base:
180105 ACC2000: The File Formats That Are Supported by Access 2000 When You Import, Export, and Link
230125 ACC2000: Using dBASE Data with Access 2000 and Jet
248841 ACC2000: How to Control Whether Access Loads the Borland Data Engine (BDE)
For more information about how to link a dBASE file to an Access database or how to import a dBASE file into an Access project, click Microsoft Access Help on the Help menu, type import a dBASE file in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Additional query words: prb
Keywords: kberrmsg kbprb KB322933
Technology: kbAccess2000 kbAccess2000Search kbAccessSearch