sorry, did you succesfully connect to your db ? i mean, where is your problem ? adding or connect ? then what was the error message ?

Practicing

what are you using ? adodb ? adodc ? adding field/column ? why dont you make it directly in access ? or did you mean insert value of your table's fields ? you can use sql - INSERT command to insert value of fields and ALTER for add and drop column... if you're using adodb.. here is the connect function Function connect() As Boolean Dim strConnect As String connect = False On Error GoTo errHandler strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\dbpakar.mdb;" Set conn = New ADODB.Connection With conn .CursorLocation = adUseClient .Open strConnect End With connect = True Exit Function errHandler: Debug.Print "ERROR! error number: " & Err.Number & ", Description: " & Err.Description End Function dont forget to declare the conn , e.g Public connVP As ADODB.Connection if you're using adodc, then just set the adodc's property. sorry if this isn't the answer that you're looking for- i misunderstood it then.. :)

Practicing