Early Binding - Sending a record from Excel to an access database

[smartpat19]

My VBA is working great my record is recorded correctly in access when I run the macro, my only issue is that every time I open a new workbook I have to reactivate the VBA Reference library : "Microsoft Office 15.0 Access database engine Object"

I will be having other co-workers (not-VBA users) running the same macro and I need it to work smoothly with them. I been reading about early binding and I'm thinking its what i need. Can i have the macro activate the reference library before I send the new record to the access database?

How can i do this?

Excel 2013
Access 2013

Thank you!

 

[Norie]

Similar/duplicate thread here.

 

[Krayons]

I hate wasting time answering already solved questions. Thank you Norie. Can someone closed this thread please as the OP's question has been answered in that other thread.

 

[RoryA]

As this was the original post, I've locked the other one.