Can't change the data type

[wilson soon]

I trying to change a data type from number to currency in
my access 2000 database and got the following message:

"Microsoft access can't change the data type. There isn't
enought disk space or memory"
"Erros were encountered during the save operation. Data
types were not changed."

This happened to the larger table 400mb. On smaller table
I am able to change the data type with no problem.

Anyone have such experience and found a solution?

 

[John Nurick]

Hi Wilson,

Try doing it in stages. First rename the number field. Then add a
currency field to the table with the original name. Then use an Update
query to copy the data from the number field. Finally delete the number
field and compact the database.

If that doesn't work - and if your database is nearing the 2GB size
limit it probably won't - make a copy of the database. Delete all
records from this table in one copy; change the field type; compact he
database; then link to the original table in the other copy and use an
append query to import the data to the modified table.