hi everybody, im new in programming i wish you can help me in my problem:
I have an access application (.mde, and .mdb), and i need to lunch(open) this application from another application in vb6.
can you help me please..its urgent
if you can please show me the details of the solution step by step
thank you

    Hi
    Here is an example on how I open an mdb from VB6. In this case
    the DB and the application are placed in the same directory.

    Dim cn As ADODB.Connection
    Dim rs As ADODB.Recordset
    Dim DbPath As String, Mysql As String

    ' Find path to database
    If Right$(App.Path, 1) = "\" Then
        DbPath = App.Path & "excelentDB.mdb"
    Else
        DbPath = App.Path & "\excelentDB.mdb"
    End If

    ' connect to database

    Set cn = New ADODB.Connection
    cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
            "Data Source=" & DbPath

    ' open a recordset

    Set rs = New ADODB.Recordset
    Mysql = "SELECT * From Tabel1"

    Set rs = cn.Execute(Mysql)

    ' do what you have to do

    rs.Close
    Set rs = Nothing
    cn.Close
    Set cn = Nothing

Hope this can help you-
Cheers
KJ