Run time 3343 after converting access database to 2010

[sween1978]

Hi

Hope someone can help. I recently converted an access database to 2010 from 2003.

When trying to access the database in excel i am now getting run time error 3343 unrecognized database format.

I tried changing the database to an accdb in the code but with no success. The bold line is the one highlighted in the debug.

Would it be easier to just run the database in the old mdb format? will this always work with the newer access?

Thanks


Dim daoApp As DAO.DBEngine
Dim dbsales As DAO.Database
Dim rssales As DAO.Recordset
Dim appXL As Excel.Application
Dim i As Integer
Dim xlfile As Workbook
Dim wks As Worksheet
Dim icount As Integer
Dim qrystr As String
Dim qrystr1 As String
Dim qrystr2 As String
Dim qrystr3 As String
ActiveSheet.Range("B8").Select
'Establish link to DAO
Set daoApp = New DAO.DBEngine
'Open Access database file
Set dbsales = daoApp.OpenDatabase _
("datbase.accdb")

[pbaldy]

What version of Excel? An older version wouldn't be aware of the newer format.

[sween1978]

The original one was excel 97-2003. I converted the excel file to 2010 format but still no success