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

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

    Hi,

    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
    message:
    "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 ?

    Thanks,

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

  2. #2
    Join Date
    Nov 2004
    Posts
    32
    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
  •