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.