Solved

Run Time Error 2147467259 (800040005) when using CopyFromRecordset to export to Excel

Posted on 2004-10-27
2,054 Views
Last Modified: 2007-12-19
This is the first time I am asking a question so I am not sure of the protocol.

The question is this:  I am using CopyFromRecordset to export a query to an excel file.  I am using an excel template to define the columns and formatting.  The query is exported when the user clicks a button.  Everything works beautifully on my PC, the memo fields are not truncated, the columns are placed under the correct headings, etc.  However, when other users attempt to export the query they receive a Run time error - 2147467259 (800040005)  Method 'CopyFromRecordset' of object 'Range' failed.   I am assuming that this is more a problem with the other users PCs but am not sure where to start checking.   I checked the references on one other person's PC and they matched mine.  Is there somewhere I can start checking for differences?  Is there something I can bring to our Systems section for them to check?
0
Question by:jkoneil
    4 Comments
     
    LVL 4

    Expert Comment

    by:CrossWired
    0
     

    Author Comment

    by:jkoneil
    How can I check to see which version of DAO is being used?  In References, we are both using Microsoft DAO 3.6 object library.
    Thanks,
    Josette
    0
     
    LVL 4

    Accepted Solution

    by:
    I was going more for the accepted answer there to check for OfficeUpates

    Go here on both machines and make sure everyone is up to date

    http://office.microsoft.com/en-us/officeupdate/default.aspx
    0
     

    Author Comment

    by:jkoneil
    Thanks.  I work in an 'interesting' environment.  No one is allowed to download anything from the internet.  I will pass this on to our Systems section and have them check on it.  

    Thanks again.

    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Cisco Complete Network Certification Training

    If you’re an IT engineer or technician, it's time you take your career to the next level. This elite training bundle is brimming with all of the information you need to learn to sit for Cisco CNNA, CCNP, and CCENT certification exams.

    This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…

    909 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now