What's .accdb? That's not a recognized database format. It should probably be .mdb. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of chaiwattr Sent: Friday, April 13, 2007 3:28 AM To: [email protected] Subject: [Access VBA Central] Connect Access 2007 problem
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. [Non-text portions of this message have been removed]
