Microsoft KB Archive/99944

= ACC: Error Exporting to Existing Paradox or dBASE Tables =

Article ID: 99944

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q99944



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:

Table ' ' already exists.

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.



STATUS
This behavior is by design.



Steps to Reproduce Behavior
In Microsoft Access 7.0 and 97:

 Create a new text file and save it as C:\My Documents\Config.dbf. This simulates a corrupted dBASE database. Start Microsoft Access and open the sample database Northwind.mdb. Select the Customers table in the Database window, and then click Save As/Export on the File menu. In the Save As dialog box, click To an External File or Database, and then click OK. In the Save Table 'Customers' In... dialog box, select dBASE III in the Save as type box.</li> Type C:\My Documents\Config.dbf in the File name box, and then click Export.</li> Click Yes to the &quot;Do you want to replace the existing file?&quot; message. Note that you receive the error message:

Table 'config.dbf' already exists.

</li></ol>

In Microsoft Access 1.x and 2.0:

<ol> Create a new text file and save it as C:\Config.dbf. This simulates a corrupted dBASE database.</li> Start Microsoft Access and open the sample database NWIND.MDB.</li> On the File menu, click Export.</li> In the Export dialog box, select dBASE III and then click OK.</li> In the Select Microsoft Access Object dialog box, select Customers and then click OK.</li> In the Export to File dialog box, type C:\Config.dbf in the File Name box, and then click OK.</li> Click Yes to the &quot;Do you want to replace it?&quot; message. Note that you receive the error message:

Table 'CONFIG#DBF' already exists.

</li></ol>

Keywords: kbinterop kbprb KB99944

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.