I am working on upgrading Access from 2003 to 2010. The steps I followed are,
Open the Access 2010
Import the old 2003 database
Run the new database application.
I am getting error 'Class does not support automation or does not support expected interface' and it is coming for the below code,
ecute ("DELETE FROM tblImportStatus")
If I change the code to - DoCmd.RunSQL ("DELETE FROM tblImportStatus")
It is working fine.
I have few other instances where I am getting same error,
ecute ("INSERT INTO tblImportStatus(FileName,F
) " & _
"Values('" & objFile.Name & "','" & objFile.Path & "','SUCCESS')")
Set cmd.ActiveConnection = Application.CurrentProject
To fix this do I need to add any references ?
As of now I added few references and the attachment have those details,