Can't change the data type
in [Help]
|
From: John Fox on 2 Dec 2009 04:31 I will give your idea of removing the data a try out. Just wondering if I have some rogue records with abnormal amounts of characters. John Salad wrote: > John Fox wrote: > >> >> Thanks >> >> Would it help then if I could change some of my fields to memo ? >> > I doubt it. > >> I have counted the number of characters in a record and the average >> seems to be about 500. > > Why are your counting characters in a record? What's the storage count > in the table structure. You shouldn't have an average. > >> >> I have tried deleting whole chunks of records while keeping >> the structure the same and that seems to help. >> >> Deleting fields while keeping the records doesn't help.' > > Deleting records helps you but modifying the structure doesn't. Why not > copy the structure, not structure and records, to a new table. Then try > to mod the new table structure. > >> >> >> John >> >> Salad wrote: >> >>> John Fox wrote: >>> >>>> >>>> dear All, >>>> >>>> I am trying to enlarge a text field from 100 to 200 characters. >>>> I get the error message 'Can't change the data type', 'not enough >>>> disk space or memory' >>>> >>>> The database is about 40Mb at the moment and has 57 fields, ( mostly >>>> text ). Using Access 2003 >>>> >>>> Any ideas? >>>> >>>> Can't see that I am short of memory anywhere. >>>> >>>> >>>> John Fox >>> >>> >>> From A97 help..."Number of characters in a record (excluding Memo >>> and OLE Object fields) 2,000" Maybe going from 100 to 200 exceeds >>> 2000. |