Changing Field Data Type

[Greg Holmes]

I have a table with 1600 records. When I try to change
the data type of a populated field from text to number, my
computer freezes up. This happens both in data view and
table view. Any suggestions?

 

[John Vinson]

I have a table with 1600 records. When I try to change
the data type of a populated field from text to number, my
computer freezes up. This happens both in data view and
table view. Any suggestions?

Create a new Table with the revised field types, and run an Append
query to migrate the data into it. Check the result, rename or delete
the old table, and rename the new one - you'll need to reestablish any
relationships. Be sure to Compact the database when you get done.