Matching DDFs to files

[dickersd]

I'm trying to view BTrieve files in Access 2000. I was told that I need to create DDFs for each file that I want to include. My question is, I currently have 5 DDFs in the directory with 30 files. Some of the files come through cleanly and others have obvious formatting problems. If I were to create a DDF for a specific file in the directory, how would I tell Access which file(s) that DDF pertains to?
Cheers,
Dave

 

[jfischer]

Typically, Access uses ODBC to connect to BTrieve files. If you've picked up an ActiveX object to read BTrieve files, then you'll need to read their documentation.

The FILE.DDF (in the FILE.DDF, FIELD.DDF, and INDEX.DDF set) should point to the physical data file. The ODBC data source should point to the FILE.DDF. (FILE.DDF and the physical data file can be on different drives, etc.)

When you connect to the ODBC data source, you can then select the BTrieve physical data file as a table name.

 

[MichaelRed]

Or, you can just build a class in VB which includes the BTrieve file structure in the construction of a private UDT in the class. It is a little bit messier than the DDF, but it is MUCH faster. Then again, I have never actually done this where the BTRieve file included variable length fields, and do not know how one would address this issue easily in VB. Fixed length records would be MUCH quicker this way.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over