Can't change the data type
in [Help]
|
From: John Fox on 1 Dec 2009 11:11 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: paii, Ron on 1 Dec 2009 11:34 "John Fox" <altabios(a)bham.ac.uk> wrote in message news:hf3f6e$fmh$1(a)north.jnrs.ja.net... > > 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 Access has a limit on record size of I believe 2048 bytes, not including memo and OLE fields. A table with 57 text fields, can easily be over this limit. Chances are you have a structure problem if you have 57 fields in one table.
From: Salad on 1 Dec 2009 11:39 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.
From: John Fox on 1 Dec 2009 11:57 Thanks Would it help then if I could change some of my fields to memo ? I have counted the number of characters in a record and the average seems to be about 500. 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. 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.
From: Salad on 1 Dec 2009 14:40
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. |