Results 1 to 11 of 11
  1. #1
    Abacus1234 is offline Competent Performer
    Windows 8 Access 2013 32bit
    Join Date
    Nov 2011
    Posts
    212

    Access references

    I have an application with fairly ancient code. It uses ms Access and word to do lots of mail merge work. At the moment the customer cannot get beyond the first screen to open a form. I want to know if I am aware of all the references that might be used for Access 2016. The ones I know about are: Visual Basic for Applications, Microsoft Access 16.0 Object Library Microsoft DAO 3.6 Object Library, and OLE Automation. Are there any others that would relate to 64 bit access? Also I'm not sure if the version of Windows affects the references, but my customer is using Windows 10 Pro. The customer is getting an error message about dll. code on a new database and 64 bit on anpther database. It works for me here on Office 2016 and Windows 8.1 64 bit.



    I would appreciate any words of wisdom. Thanks.

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    There are 4 standard references that should be used with all ACCDB files and which are added by default

    Click image for larger version. 

Name:	Capture.PNG 
Views:	21 
Size:	17.4 KB 
ID:	38740

    The screenshot is from A2010. In Access 2016/365, the version numbers will be 16.0 instead of 14.0
    The final reference in the list above is a replacement for the old DAO reference and provides additional functionality.
    As the two libraries overlap, you can't use both.

    AFAIK, there are no references specifically for 64-bit Access.
    The error message your 64-bit user is getting may indicate API declarations that need updating for 64-bit
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    If you're manipulating Word in VBA, you will also need the Microsoft Word xx.0 Object Library.

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Quote Originally Posted by davegri View Post
    If you're manipulating Word in VBA, you will also need the Microsoft Word xx.0 Object Library.
    Not if using late binding.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Quote Originally Posted by davegri View Post
    If you're manipulating Word in VBA, you will also need the Microsoft Word xx.0 Object Library.
    Unless you use late binding.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  6. #6
    Abacus1234 is offline Competent Performer
    Windows 8 Access 2013 32bit
    Join Date
    Nov 2011
    Posts
    212
    Thanks to all. I am using .mdb access, and late binding.

  7. #7
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Just wondering why you are using an MDB file when you said you were working in A2016?
    For MDB, the old DAO reference is correct. In fact you won't be able to use the newer reference I mentioned

    Perhaps you should also update your profile which says A2013 32-bit
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  8. #8
    Abacus1234 is offline Competent Performer
    Windows 8 Access 2013 32bit
    Join Date
    Nov 2011
    Posts
    212
    Hi Colin, I have customers on many different versions of Office and Windows, and I have a variety in the office. Sorry did not mean to confuse.

  9. #9
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    No problem ...but in this case it really would have helped to know the full facts.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  10. #10
    Abacus1234 is offline Competent Performer
    Windows 8 Access 2013 32bit
    Join Date
    Nov 2011
    Posts
    212
    Hi Colin, My customer is getting no help from Microsoft. I have just tried to download Windows 10 Pro wo I would have the same setup as theu customer, but the install failed and Microsoft admitted it was a problem with the install and the Windows 10 ISO file. MS Development are currently looking into it. If my code needed changing, I believe I would already have heard from customers, so I am assuming that mu customer has either a corrupt dll file or a bad registry entry. Despite the fact that he upgraded his system just a week ago, and went back to them to help unstall Office and reinstall (which messed up his outlook and took hours to fix). They want him to pay $499 to get some help.

    On my system, I believe the dll file in question is ACEDAO.dll which I find in Program Files (x86). My customer's ACEDAO.dll is in Program Files.
    I would have thought that just downloading ACEDAO.dll and replacing it would have determined if it was corrupt or not.
    Could anyone tell me what the registry should read for a Windows 10 Pro, and Office Home and Student 2016?
    Thanks.

    Problem solved: Needed Microsoft Engine Object Library for dll error message and PtrSafe added between Declare and Function for code to work. Thanks
    Last edited by Abacus1234; 06-14-2019 at 03:30 PM. Reason: Problem Fixed

  11. #11
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    The location of ACEDAO.dll depends on the bitness of Windows And Access.
    In your case you have 32-bit Access and 64-bit Windows so its located in the x86 subfolder.
    However its irrelevant for an MDB file as that reference cannot be used as I mentioned before.
    Instead you are using DAO360.dll

    Unable to answer any questions specifically about the Home and Student version of Office but I thought that didn't include Access
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 07-29-2016, 07:02 PM
  2. References in Access 2010
    By RayMilhon in forum Modules
    Replies: 6
    Last Post: 09-28-2015, 11:15 AM
  3. Access compile and check for references
    By jassie in forum Programming
    Replies: 5
    Last Post: 05-20-2015, 08:28 AM
  4. Sharepoint Access Services References
    By is49460 in forum SharePoint
    Replies: 0
    Last Post: 11-09-2010, 09:42 PM
  5. Best References on Access
    By evander in forum Access
    Replies: 4
    Last Post: 10-14-2010, 10:58 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums