Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

ACC: Error When Importing dBASE, FoxPro, or Paradox Table


View products that this article applies to.

Symptoms

In Microsoft Access 97, when you import a Paradox file that does not contain a file extension as part of its name or does not follow the MS-DOS 8.3 file name format (that is, an 8-character name followed by a 3-character extension), you may receive the following error message:
The Microsoft Jet database engine could not find the object '<filename>'. Make sure the object exists and that you spell its name and the path name correctly.
Note This error may also occur with a dBASE file in Microsoft Access 97, if the file name does not follow the MS-DOS 8.3 file name format.

In Microsoft Access 2.0 and 7.0, when you import a Paradox file that does not contain a file extension as part of its name, you may receive the following error message:
Couldn't find object '<filename>'


In Microsoft Access 1.x, when you import a dBASE, FoxPro, or Paradox file that does not contain a file extension as part of its name, you may receive the following error message:
Couldn't find object '<filename>'

↑ Back to the top


Resolution

Rename the file so the file has the correct extension, such as .dbf for a dBase file.

Note Although incorrect extensions may have been permitted in the past, as of February 2003, current versions of Jet require that the correct file extension is used for security reasons.

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
240770 OFF: Frequently Asked Questions About the ODBC Driver Security

↑ Back to the top


Status

Microsoft has confirmed this to be a problem in Microsoft Access 1.x, 2.0, 7.0, and 97.

↑ Back to the top


More information

Steps to Reproduce Problem

The following steps use a Paradox file as an example. You can also use a dBASE or FoxPro file to reproduce the error message in Microsoft Access 1.x.
  1. Rename a Paradox file so that it has no extension. For example, rename Customer.db to Customer.
  2. Open a Microsoft Access database.
  3. Import the file:

    In Microsoft Access 7.0 and 97:

    1. On the File menu, point to Get External Data, and then click Import.
    2. In the Import dialog box, click Paradox (*.db) in the Files of Type box.
    3. Type *.* in the File Name box.
    4. click the Paradox file that you created in step 1.
    5. Click Import.
    In Microsoft Access 1.x and 2.0:
    1. On the File menu, click Import.
    2. In the Import dialog box, click the appropriate version of Paradox, and then click OK.
    3. In the List Files Of Type box, click All Files (*.*).
    4. Click the file that you created in step 1.
    5. Click Import.
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.

↑ Back to the top


Properties

↑ Back to the top


Article Info
Article ID : 95327
Revision : 5
Created on : 1/1/0001
Published on : 1/1/0001
Exists online : False
Views : 378