I am wanting to change the field type of a field in an Access Database, it has data and anywhere up to 1500 records in the table. I want to change the data type of the field from a Text to a Long Integer. Does anyone know how? Chris Crowe [EMAIL PROTECTED] Want a free tool to help search the Microsoft BB and Search pages?, goto http://www.adrock.com/msarticle --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz