Not enough disk space or memory to undo chnes

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
 
J

John Vinson

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]
 
Top