Solved

linking xbase and clipper files to .mdb files

Posted on 1998-08-07
3
398 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
ID: 1958524
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
ID: 1958525
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
ID: 1958526
That's Sequiter.  One q
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

911 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

17 Experts available now in Live!

Get 1:1 Help Now