How to execute Line of Code

[jo15765]

Dim AccessDB As DAO.Database

Everytime I Try to run this line of code it errors on me. Something about unrecognized...or another, I know I should have the exact code, but I don't sorry!!

Can someone explain to me how exactly to implement this code in your db and have it execute error free?!

[boblarson]

You have to set a reference to

Microsoft ActiveX Data Objects 2.8

By going to the VBA Window, to TOOLS > REFERENCES and finding that in the list of potential references and then checking the box next to it.

[jo15765]

Would that be the case if I can run a db that has the same command in there error free, but when I copy the same code line for line to update a different db it errors?

[boblarson]

Would that be the case if I can run a db that has the same command in there error free, but when I copy the same code line for line to update a different db it errors?

That reference is a PER DATABASE setting so you would have to set it in the other database for it to work.

[jo15765]

Wonderful! Thank you so much!