Change Text Field length. (Out of Memory Error)

[Phi1Smith]

I have a text field in a table with 250000 records that is currently set to 25 characters long. I would like to change this to 35 characters long, but as access attempts to change the data it returns an error "Not Enough Memory or Disk Space". I had 85Mb of ram empty at the time of the error & disc space can't be the problem far to much to spare. Is there a way round this anyone know?

Many Thanks

Phil Smith

 

[KHerm]

I'm not an expert, so maybe I shouldn't be answering this, but I believe the problem is the size of the Access database (1 gig or 2 gig for Access2000). The database may need to be compacted. I think I ran into this once myself (or I wouldn't be answering at all) and what I did was create a blank Access database, copy the table to the blank database, make the change, delete the original table in the original database, compact that database, then copy the table back.

Ken

 

[Phi1Smith]

Many Thanks KHerm, I did the changes in a blank database with just the 1 table in with no errors at all.

Thanks Again

Phil Smith