Sounds a long winded way of doing it, do you think that is the only way? Access can alter it pretty quick from within the IDE, do you think it is using that method? Chris -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Grant Black Sent: Monday, 18 October 1999 11:59 To: Multiple recipients of list Delphi Subject: RE: [DUG]: Changing a field type in an Access Database Use SQL DDL to Append a temp field, copy data, Delete & Add the old field with the new type ie .. ALTER TABLE a_table ADD tempfield STRING INSERT INTO tempfield SELECT thefield ALTER TABLE a_table DROP thefield ALTER TABLE a_table ADD thefield INTEGER copy data back.. ALTER TABLE DROP tempfield Grant Black Software Developer SmartMove (NZ) Ltd Phone: +64 9 361-0219 extn 719 Fax : +64 9 361-0211 Email: [EMAIL PROTECTED] > -----Original Message----- > From: Chris Crowe [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 18, 1999 11:25 AM > To: Multiple recipients of list Delphi > Subject: [DUG]: Changing a field type in an Access Database > > > 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 > --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
