Hello! I have problem from connect Access 2007 with Microsoft.Jet.OLEDB

Const DB_PATH = "C:\AccessSample\AccessDb\NProduct2007.accdb"

Function AddNewEmployee() As Long
On Error GoTo Error_Handler
    Dim cn As New ADODB.Connection
    Dim rs As New ADODB.Recordset

    cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                "Data Source=" & DB_PATH & ";" & _
                "user id=admin;password=;"

...

End Sub

This connection found error "-214767259 Unrecognized database format 
C:\AccessSample\AccessDb\NProduct2007.accdb". But it still could 
connection with Access 2003.

What I need to do for solved this problem. Pls, advise.



Reply via email to