ACC2000: Error Exporting to Existing Paradox or dBASE Table (209540)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q209540
Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

In Microsoft Access, you cannot export a Paradox or dBASE table over the top of an existing, corrupted Paradox or dBASE database file. If you try, you receive the following error message:
Disk or network error
This error occurs with both dBASE and Paradox formats. Other database exports allow you to overwrite existing database files.

CAUSE

Microsoft Access tries to open the file to verify its contents, instead of simply overwriting it.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Create a new text file and save it as C:\Config.dbf. This simulates a corrupted dBASE database.
  2. Start Microsoft Access and open the sample database Northwind.mdb.
  3. Select the Customers table in the Database Window, and then click Export on the File menu.
  4. In the Export Table 'Customers' To dialog box, select drive C from the Save in box, type Config.dbf in the File name box, click dBASE III (*.dbf) in the Save as type box, and click Save.
  5. Click Yes when you get the message:

    The file Config.dbf already exists. Do you want to replace the existing file?

    Note that you receive the error message:
    Disk or network error
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbinterop kbprb KB209540
©2004 Microsoft Corporation. All rights reserved.