Hi, Access 2007 is based on a version of Jet that is later than 4.0. So I suppose that Jet 4.0 can't read Access 2007 databases.
However, Access 2007 can read and write databases in earlier formats, which would be accessible via Jet 4.0. Good luck, Peter Hoogenboom --- In [email protected], chaiwattr <[EMAIL PROTECTED]> wrote: > > 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. >
