[AccessD] Change field data type programmatically

Mark
When we were writing the BEU we found that this was a limitation of code
- couldn't do it. As Charles suggest you can certainly create a new
field, query the data across and delete the old, all in code, but take
care of indexes and relationships.
IIRC though the SQL ALTER TABLE command gained an ALTER COLUMN bit in
Access XP which hadn't been there in A97.
 
Andy Lacey
http://www.minstersystems.co.uk <http://www.minstersystems.co.uk/>  

 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Boyd
Sent: 29 July 2003 19:33
To: AccessD at databaseadvisors.com
Subject: [AccessD] Change field data type programmatically



How can I change a data type in code?

I want to change Field1 from Date/Time to Text.

Any ideas?

 

Thanks,

Mark Boyd

Sr. Systems Analyst

McBee Associates, Inc.

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030729/96346322/attachment-0001.html>