How can I open Dbase IV file in VB?

[wangwien]

I want to use a DBase IV file in VB, PLS teach me how to write it?

[santulan]

hi...
Use DAO ( Data Access Object ). Data Control OCX. Rememeber following -
1. In Connect Property select Dbase IV. (This is a combo type selection)
2. In database name, select only that sub-directory where dbase files resides.
3. In recordsource property please use the actual dbf file.
4. After that you can access its fields by simply binding then to any text box, etc controls.



Santulan

[wangwien]

I want to use the Dbase IV file as Access a recordset, I can add, edit, Delete.Search and so on,Can I do it?

[santulan]

Yes! you can do it. Once it is recordset, you can apply any valid operation. Just do it. recordset.add
recordset.edit
all commands will work fine. Just give a try. :-)
Same time, find possibilities to convert the stuff into minimum Access... if possible.


Santulan

[Amendra]

Do you know the exact method of connecting to a dbase file's at runtime. I tried using the format given in the help, but this doesn't work.

Amendra

[wangwien]

I use this code to open a Access file:
Set Data_Merge = OpenDatabase("c:\merge\merge.mdb")
Set RS_Merge = Data_Merge.OpenRecordset("select * from merge")

It work very well. When I want to use a another Dbase IV file, I use code like follow:
Set Data_Merge = OpenDatabase("c:\merge\dbase4.dbf")
But at runtime return a wrong "Unrecongnized database format". PLS teach me how I change the code and let the programme run?

[Un1]

Try this high performance DBF engine: (VB source code include)
http://www.banasoft.com/DownLoad/BNxBase.exe