?
Solved

linking xbase and clipper files to .mdb files

Posted on 1998-08-07
3
Medium Priority
?
445 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 400 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

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

569 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