I'm using VBA 6.3 and I'm trying to import an Access 2007 database file (accdb). I've installed AccessDatabaseEngine.exe from Microsoft and checked Microsoft Office 12 access database engine object library from the References menu.
Though, the following code:
always returns the error 3044 ("C:\mypath\mytable.accdb" is not a valid path). Of course, I've checked the path and the file name and they're ok. Do you know what's going on? Must I necessarily use ODBC?Code:Dim db As DAO.Database Set db = DBEngine.OpenDatabase("C:\mypath\mytable.accdb")