Not enough disk space or memory to undo chnes

  • Thread starter Thread starter Pete Provencher
  • Start date Start date
P

Pete Provencher

Using Access 2000:

Trying to update one field from one tale to another table. The update would
effect 167,956 records. When I run the update I get "not enought disk space
or memory to undo the changes". I have 1 gig of ram. Any suggestions?

Pete Provencher
 
Using Access 2000:

Trying to update one field from one tale to another table. The update would
effect 167,956 records. When I run the update I get "not enought disk space
or memory to undo the changes". I have 1 gig of ram. Any suggestions?

Pete Provencher
Click to expand...

Just click the "run it anyway" button. A current backup of your
database would be prudent, but all the message is saying is "you're
updating too many records for me to save the changes and let you
Ctrl-Z if you should change your mind" - it's not saying it can't run
the query.

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Not enough space on temporary disk. 1
How to Bypass "not enough memory to undo" nmessages 2
Not enough space on temporary disk 5
Out of Disk Space Error??? 4
Using Not Like 10
Not enough disk space or memory 7
Not Enough Space on Temporary Disk??? 2
there is not enough memory or disk space to run Word 1

Back
Top