Compile Error: Method or Data Member not found. Data Append MVF to Access From Excel.

[pedie]

Hi Guys!
'm try to upload file as attachement to Access from Excel.
This perfectly works in Access to Access even Accross databases but from Excel to Access this Problem is happening...
it errors in Underlined Code line below
Please advice.

[/FONT]
[FONT=Courier New]Dim db As DAO.Database
Dim ws As DAO.Workspace
Dim rst As DAO.Recordset
Dim MVFrst As Recordset[/FONT]
[FONT=Courier New]Dim rs As DAO.Recordset[/FONT]
[FONT=Courier New]
Set ws = DBEngine.Workspaces(0)
Set db = ws.OpenDatabase("C:\Budget_Expense.accdb", False, False, "MS Access;PWD=")
Set rst = db.OpenRecordset("Select * FROM MyTb;", dbOpenDynaset)[/FONT]
[FONT=Courier New]rst.AddNew
rst!Expense_Detail = "Test Title"
Set MVFrst = rst.Fields("MyAttachment").Value
MVFrst.AddNew
[U]MVFrst.Fields("FileData").LoadFromFile "C:\Book1.xls"
[/U]MVFrst.Update
rst.Update[/FONT]
[FONT=Courier New]If Not rst Is Nothing Then
rst.Close
Set rst = Nothing
End If
If Not db Is Nothing Then
db.Close
Set db = Nothing
End If
If Not ws Is Nothing Then
Set ws = Nothing
End If

 

[pedie]

Try to reference the Microsoft DAO 3.6 Object Library

No:

It has to be the MS Office xx Access database engine object lib

I have tried that too...
DAO
ADO
i cant locate 'MS Office xx Access database engine object lib'

Please note i'm running this code from Excel.

 

[Norie]

The right reference is the one Charles suggested earlier which is in Excel and you don't need to change any of the code.

PS If you get a name conflict whem you add that reference then uncheck the DAO reference.

 

[pedie]

Try to reference the Microsoft DAO 3.6 Object Library

No:

It has to be the MS Office xx Access database engine object lib

Kreszch68, finally I got the reference lib. Thank you very much!!!!
it is working.... perfect!

Thanks Norie, thanks everyone!

 

[Norie]

Pedie

Which reference did you eventually use?

 

[pedie]

Pedie

Which reference did you eventually use?

I located and used 'MS Office xx Access database engine object lib'