Can't Change data type

[jane30]

Hi, in my Access 97 database, I tried to change one field's data type, I got an error message, saying that "Microsoft Access can't change the data type. There is no enough disk space or memory."

Sometimes I'm able to change the data type of a field in a table, sometimes I get the error message as above-mentioned. What matters then? the size of the table? the size of the database? or something else? The table I tried to change the data type contains over 189,000 records with 35-40 fields. When I tried to change the data type (from text to number), the database size was 498mb. Any help is appreciated.

 

[MazeWorX]

http://support.microsoft.com/default.aspx?scid=KB;en-us;161329&

You might find the following article interesting Remember amateurs built the ark - professionals built the Titanic