accdb is the new default database format for Access 2007.
--- In [email protected], "Dana" <[EMAIL PROTECTED]>
wrote:
>
> 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]
>
