Changing Field Data Type

  • Thread starter Thread starter Greg Holmes
  • Start date Start date
G

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?
 
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?
Click to expand...

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.
 
Back
Top