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

Posted on 2004-10-27
Medium Priority
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?
Question by:jkoneil
  • 2
  • 2

Expert Comment

ID: 12426588

Author Comment

ID: 12426766
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.

Accepted Solution

CrossWired earned 2000 total points
ID: 12426796
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


Author Comment

ID: 12426935
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.


Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

600 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