Solved

linking xbase and clipper files to .mdb files

Posted on 1998-08-07
3
387 Views
Last Modified: 2008-02-01
I was wondering if anyone has had this problem and if anyone has a solution.  I am working with an access database and trying to link an xbase/clipper database to it.  The problem is that it is an unrecognized file format with unsupported index files.  Does anyone know of a way to bypass this problem so that the dbf database can be updated when the mdb one is?  Can this be done via Visual Basic 5.0?  Any comments will be a help.  Is there a specific xbase/clipper driver that may be needed?
0
Comment
Question by:harttra
  • 2
3 Comments
 
LVL 4

Expert Comment

by:tomook
Comment Utility
When Access asks for the index, you should be able to skip it. I do not know what effects that will have.
0
 
LVL 9

Accepted Solution

by:
cymbolic earned 200 total points
Comment Utility
Access does not have a driver that understands the CLipper .NTX files.  You can link to the .dbf, and Access will read/import them, but that does you no good if you want to update in parallel with access tables.

The best software library for modifying Clipper dbf/index files is available from Seqquiter software.  They have a site on the web.  I have used their libraries for years in conjunction with Clipper databases, and they are completely compatible and interwork with CLipper Apps on the same database without causing problems. They even use the same record locking scheme.
0
 
LVL 9

Expert Comment

by:cymbolic
Comment Utility
That's Sequiter.  One q
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now