Dear All members,
I want to make one application which add, edit & delete data to .dbf file. I want to know that How can I make connection with .dbf file using ADO & DAO.

Pl. any one know help me.

Thanx in advance for the help

You can use UDL files to easily create & setup your connection strings, try this first:

1) Create a new text file on your pc, then rename the extension from *.txt to *.udl.
2) Open the file & you'll see a wizard type screen, select the 1st tab, then work your way through the screens & click the OK button when you've finished.
3) Rename the *.udl extension back into *.txt and open the file up. You should see in the very bottom line only the resulting connection string which has been built for you here.

Remove the ";Persist Security Info=False" part of the bottom line, as well as any lines above this from the file, then copy the final text you're left with into either of these samples:

' ADO METHOD, NOTE YOU'LL NEED A REFERENCE SET FROM THE PROJECT
' MENU > REFERENCES SCREEN TO 'MICROSOFT ACTIVEX DATA OBJECT x.0
' OBJECT LIBRARY'. THE x WILL DEPEND ON YOUR INSTALLED VERSION OF
' ADO, BUT IF YOU CAN USE IT, GO WITH VERSION 2.6 IF IT'S THERE.

Private Sub Form_Load()
    Dim cnnADO As ADODB.Connection
    Set cnnADO = New ADODB.Connection

    cnnADO.ConnectionString = "TheUDLFileTextHere"
    cnnADO.CursorLocation = adUseClient
    cnnADO.Open

    ' Other work here ...

    Set cnnADO = Nothing
End Sub

' DAO METHOD, NOTE YOU'LL NEED A REFERENCE SET FROM THE PROJECT
' MENU > REFERENCES SCREEN TO 'MICROSOFT DAO OBJECT x.x OBJECT
' LIBRARY'. THE x WILL DEPEND ON YOUR INSTALLED VERSION OF DAO.

Private Sub Form_Load()
    Dim dbDAO As DAO.Database
    Set dbDAO = New DAO.Database

    dbDAO.Connection = OpenDatabase("TheUDLFileTextHere")

    ' Other work here ...

    Set dbDAO = Nothing
End Sub

Probably should add a line to close the connection:
   cnnADO.close
I think?