ACC: Attaching Clipper Tables to Microsoft Access Databases (95044)



The information in this article applies to:

  • Microsoft Access 1.0
  • Microsoft Access 1.1
  • Microsoft Access 2.0
  • Microsoft Access for Windows 95 7.0
  • Microsoft Access 97

This article was previously published under Q95044
Moderate: Requires basic macro, coding, and interoperability skills.

SUMMARY

It is possible to link (attach) Clipper .dbf files to a Microsoft Access database. To do so, link the file as a dBASE IV file. Note, however, the index may or may not be updatable.

Clipper provides an alternative indexing method (.ntx) to the dBASE standard (.ndx). The Clipper index format is not recognized by Microsoft Access; therefore, Microsoft Access cannot update it correctly.

However, if the Clipper application was developed by using the dBASE .ndx format, Microsoft Access updates the index correctly.


Modification Type:MajorLast Reviewed:5/9/2003
Keywords:kb3rdparty kbinfo kbinterop KB95044