Change library reference location

[BruceM]

A user in our office has 64-bit Office. A VBA project will not compile because of a missing DAO 3.6 reference. The dao360.dll file is in C:\Program Files (x86)\Common Files\microsoft shared\DAO. However, the VBA reference (used in an Add-in) is to the same location, except Program Files rather than Program Files (x86).

I have tried registering the file with regsvr32 (I don't know if there is a different option for 64 bit). While the registration is reported as successful, the reference in the VBA editor (Tools > References) remains at Program Files instead of Program Files (x86). I am sure there is something about this registration process I do not understand, but everything I have been able to find other than VBA solutions seems to indicate something along the lines of what I have already tried without success.



Edit: To provide a little more information, the DAO 3.6 reference is because a user form is getting the row source for a combo box from an Access file.