diverting dBase IV data writes to dbf files to SQL7 tables

diverting dBase IV data writes to dbf files to SQL7 tables

Post by Bob Lamberso » Sat, 26 Feb 2000 04:00:00

We're about to rewrite a vdBase app in vb6 / sql7 server, and want to be
able to continue using the vbBase app while building and using the new vb6
app. If we can solve the problem of how to get the vdBase app to write to
sql, the rest of a data syncronization process will be done in vb6 objects.
Any ideas or shared experiences along these lines will be appreciated.
    Bob Lamberson


1. Using ADO to open cdb files (these are actually dbf dbase IV files)


Thanks in advance for any reply...
For a legacy application I need to link a dbase IV file in MS Access;
I use ADO in VBA to not to need a manual link and no need for an DSN entry
in the ODBC manager;
All is working fine if I rename the file.cdb to file.dbf, however if the
legacy application is running, I'm not able to rename the file since it's
Note that I only need read access to the table except when the legacy app
isn't running, then I need write access.
So in all, I want to open a file.cdb as an file.dbf without renaming,
there's also an index file with the extension file.mdx, I asume that
extension is fine and is automatically incorporated ?


2. Bad output from xp_sqlmaint on 7 SP3

3. Exporting dBASE IV memo field to ASCII file without using dbase IV

4. renaming a cloumn

5. C code to search dBASE IV .dbf file?

6. Clarification

7. How to delete a recordset of dBASE IV DBF file use VB4

8. 8i/9i teaching notes/tips needed.

9. Dbase III+ / IV file format (DBF)

10. dBase IV dbf file format

11. C code to search dBASE IV .dbf file?

12. Problem with exchanging DBF files between REXL and Dbase IV

13. Edit DBF (DBASE IV) file using ADO