View Single Post
 
Old 12-08-2015, 12:27 PM
BruceM BruceM is offline Windows 7 64bit Office 2010 32bit
Advanced Beginner
 
Join Date: Feb 2015
Posts: 41
BruceM is on a distinguished road
Default Change library reference location

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.

Last edited by BruceM; 12-09-2015 at 05:31 AM. Reason: Further information
Reply With Quote