I have an MS Access 2000 database/MDB that contains a table containing 770,000 records in it. It consists of approx. 10 records, all text, none greater than 64 characters in width. I wanted to change the record length of one of the fields from 7 characters to 5. I used the DESIGN TABLE tool and changed this record's length value to 5 (from 7) and closed the window. After confirming that I was aware that I might lose some data due to the truncation, the progress bar began progressing and got to 75% when the following window popped up, stopping the conversion:
Microsoft can't change the data type. There isn't enough disk space or memory.
And yet I have gigs of free disk space, and 512mb of RAM.
I don't buy Microsoft's message that there isn't enough disk space or memory. Nothing I can see using ALT+CTL+DEL and checking the Memory Usage comes close to confirming that I am running out of memory during this procedure.