none
Access cannot export the large file RRS feed

  • Question

  • Hello,

    I am using sql and macro to export data to excel daily, but recently it only export small size of data and couldn't export large size of data in the macro. please see the image below while running the macro, but the rest file can export even this error msg occurs:

    How to enhance the performance to allow Access to export large too?

    Thank you very much and hopefully somebody can help.

    Lawrence

    Wednesday, April 19, 2017 6:06 AM

All replies

  • You tried to save changes in a database that was opened for read-only access.

    The database is read-only for one of these reasons:

    • You used the OpenDatabase method and opened the database for read-only access.
    • In Microsoft Visual Basic, you are using the Data control, and you set the ReadOnly property to True.
    • The database file is defined as read-only in the operating system or by your network.
    • The database file is stored on read-only media.
    • In a network environment, you do not have write privileges for the database file.
    • When working with a secured database, the database or one of its objects (such as a field or table) may be set to read-only. You may not have permission to access this data with your user name and password.

    Close the database, resolve the read-only condition, and then reopen the file for read/write access.

    Wednesday, April 19, 2017 7:15 AM
  • Hi Jafinmaria,

    the target txt file has been set like the image below, how can I change it to not "ReadOnly":

    Thank you for your concern and look forward to your reply.

    Lawrence

    Wednesday, April 19, 2017 7:57 AM
  • Hi Lawrence,

    I notice that you are using Macro for data exporting from Access to Excel. This forum focuses on general discussion for Excel features.

    To better resolve the issue, I would move the thread to Access for Developers forum for further troubleshooting. The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.


    Regards,

    Winnie Liang


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Thursday, April 20, 2017 2:50 AM
  • What is the database's file size?

    Have you tried a Compact and Repair?
    Does your VBA code compile without errors?

    You could always try a slightly different approach to exporting the data using Excel automation, see https://www.devhut.net/2012/04/19/ms-access-vba-export-records-to-excel/


    Daniel Pineault, 2010-2016 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Thursday, April 20, 2017 10:03 AM