0

Im trying to display records from my access 2010 64 bit database into word footer, when I run the code I get ActiveX can not create object. I do have reference in my vba project microsoft dao 3.6 object library and microsoft activex data objects 6.1 libraries. The code is working fine on 32bit but not 64 bit. Any ideas? Debug pointing to this line as error:

Set dataBase = DBEngine.OpenDatabase(UsersBasePath)
user3573958
  • 1
  • 1
  • For access 2010, or at least .accdb s created in 2010, I think you need the Microsoft Office 14.0 Access Database Engine Object Library instead of the DAO one. –  Apr 25 '14 at 21:26

1 Answers1

0

I had to add dao in the front of the database declaring statement

user3573958
  • 1
  • 1
  • Hi, Could you please explain this in more detail? I am struggling with the same issue here. Thanks! – Bjoern Aug 25 '16 at 15:18