Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-08-2015, 12:27 PM
BruceM BruceM is offline Change library reference location Windows 7 64bit Change library reference location Office 2010 32bit
Advanced Beginner
Change library reference location
 
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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change library reference location Microsoft Excel 12.0 Object Library reference upload chamdan Project 2 04-21-2014 06:30 AM
Change library reference location Change default location for save does not work sportflyer Word 4 02-06-2014 04:43 PM
Can't change inbox data file location Stephen Waugh Outlook 0 01-10-2013 01:13 PM
Change library reference location How to change save location and file to print name change? albertc Excel Programming 1 05-13-2012 07:05 PM
Change library reference location Excel VBA: How to add a reference to Microsoft Word Object Library? tinfanide Excel Programming 7 12-12-2011 05:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:03 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft