Link to home
Start Free TrialLog in
Avatar of Skip Sleeper
Skip Sleeper

asked on

Access 2010 64 bit Compile Error on DAO recordset, can't load DAO 3.6 library

Hi Experts,

Rey Obrero kindly gave me a loop that works perfectly on two computers in the sample database we shared.  When I copy the code to the same form on the original database I get a compile error "user defined type not defined" at Dim rs AS DAO recordset.  My research indicates that I'm missing the MS DAO 3.6 Object Library but I can't load it.  I've tried the Mr. Fix It tool from MS without joy.  Don't have a lot of enthusiasm for manually working with the registry but could if needed with good instructions.  In the References list there are no missing items and VBA, Access 14.0 and VBA Extensibility objects are checked.  I've included the sample database and the original for comparison.  Any assistance would be greatly appreciated.  Thanks!
Sample-Database-Loop-Solution.accdb
Menus.accdb
Avatar of MINDSUPERB
MINDSUPERB
Flag of Kuwait image

In the Tools>Reference, activate Microsoft DAO 3.51 Library.

Sincerely,

Ed
ASKER CERTIFIED SOLUTION
Avatar of Bitsqueezer
Bitsqueezer
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Skip Sleeper
Skip Sleeper

ASKER

Hi,

Thanks for the solution and the advice on the field--much appreciated!
Thanks, you're welcome.