Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005

    Question Unanswered: There isn't enough disk space or memory to undo the data


    I'm trying to append a table (about a 2,00,000 records) to the
    main table (about 10,00,000 records) .
    After running an append query in Access the machine is
    blocked for a few minutes, then I receive a following
    "There isn't enough disk space or memory to undo the data
    changes this action query is about to make."

    I click ok, then the query has continued.

    I've got plenty of disk space and 256mb of RAM!

    Any ideas, I don't want to get that warning . How could i do it ?


    Last edited by i_chari; 02-11-05 at 02:09.

  2. #2
    Join Date
    Nov 2004
    I don't know what exactly is causing the message, but there are a few things I'd try first.

    Increase the size of your swap file.
    Defrag the hard drive.
    Compact and repair the database.
    Make sure I'm using at least AccessXP for that size of database, and use the MSDE backend for the tables....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts