MS Access 2013 crashes continually on different computers.

1.  I wasn't suggesting to set a Reference to and earlier one.  Access 2013 does not play nice with earlier versions which is why I wanted to know what version of Excel you have instaled.

2. You mentioned you sometimes get an error ad I was tryng to figure out want you were trying to do that produced that error.
3. <grin> that is why I capitalized the RE, just to say do it again if any Module was missing either line.

Hmmm, running out of ideas BUT... Do you get a chance to press Debug when an error happens or does it just crash.  If you can press Debug then it would be nice to know what line is causing the error.

Hi Gina,

1.  Excel 2013 is the only entry when I type "Excel" in my start menu.  For the most part, I am using late binding...but at some point I'll completely make the switch and let you know how that works.  There is no option for me to set a reference to Excel 14 in VBA (only Excel 15)

2.  Not sure what this question is asking.  I'm explicitly using DAO.Database, and DAO.Recordset, and using "CurrentDB()".  Sounds like I don't need to set a Reference to DAO 3.6 - which would make sense as I didn't have one set while using Access 2010 (before the upgrade) and all was working just fine.

3.  Yes.  Every module (class, form, module...) has Option Compare Database and Option Explicit.  Out of curiosity, I don't see an option under the debug menu called "RE-compile"...I just see "Compile".  As a side note, I've also tried the "Decompile" suggestion but that didn't help.

4.  32 bit Access (Office Professional Plus) running on Windows 7 64 bit.

Any suggestions?

Sorry for the delay...  I just got the eMail that you replied!

1. Do you have both versions of Excel installed?  (You might want to use Late Binding for the Excel library, that way no worries about versions.)
2. What other DAO Libraries?  (If you are trying to set a Reference to the DAO Library you don't need to, it's included in the Microsoft Office Access database engine Object Library.)
3. Does each Module have...

Option Compare Database

Option Explicit

...at the very top.  If it does not you need to add it and Debug>RE-ompile to check for errors.

4. 32 bit Access or 64 bit Access?

Hi Gina,

I have the following references loaded:

• Visual Basic For Applications
• Microsoft Access 15.0 Object Library
• OLE Automation
• Microsoft Office Access database engine Object Library
• Microsoft Excel 15.0 Object Library

Although I do make references to DAO objects, I don't explicitly have the DAO Library Object reference set because:

1.  Each time I try it to set the reference, it gives me the following error (message box <!>):  Name conflicts with existing module, project, or object library.

2.  When I compile my code, I don't get an error regarding a missing reference.

I tried running the "Fix It for me" here (http://support.microsoft.com/kb/2019235) for Windows 7, but that didn't seem to work.

I'm running Windows 7 64bit, with Office 2013 Pro Plus 32 bit (upgraded from Office 2010 Pro Plus 32bit).

What References do you have set?