change field properties

[Guest]

Using Access 2003. I have a database with over 400000 records, and need to
change the properties on three of the fields. When I attempt this it works
for a while and then just locks up. Any suggestions on how to get this to
work?
Any help greatly aprreciated.

 

[Douglas J. Steele]

I'd suggest creating a new database.

Set the table up the way you want in the new database. Link to the table in
the old database, and create an Append query to populate the new table.