Look at the ADOX.Column object and its Type property. (I haven't used it to actually *change* the data type of a column, but I assume it would work OK).
The leap from a Long Int to a Double seems like a strange one. If you only need to represent larger values, look into using Decimal or Currency instead. Floating point values carry the rounding problems into the natural number range for large numbers. Always use a discrete numeric datatype to represent discrete values. HTH, Tore. -----Original Message----- From: Zaid Abdur-Rahman [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 10:59 AM To: ActiveServerPages Subject: Fw: Change Data Type of Access field Hello All, Is there a way to change the Data Type of a field in an Access DB, programmatically? I have a field that is of type "Long Int" that I want to change to "Double". Many thanks Zaid Abdur-Rahman [EMAIL PROTECTED] --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
