Changing a Data Type within a table

[Carly]

Is there anyway in VBA that I can open a table and then change the data type of a field from Number to text and close the table again?

I have got the following for the opening & closing the table but it's the data type bit which I am missing:

Docmd.OpenTable "tbl 1c Final Product Sales By Qty", acViewDesign, acEdit
..........
Docmd.Close actable "tbl 1c Final Product Sales By Qty", acSaveYes

Can this be done?

Regards
Carly

 

[crosmill]

you can use the sql command
ALTER TABLE


but I'm not sure if access supports it......?

 

[fuzzygeek]

One way

Go to the following link. Go to Defining and Retreiving a Database's Schema and then select Creating and Modifying Tables . Then scan down to changing columns in a table. It will show both DAO and ADO code for doing this.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndao/html/daotoadoupdate.asp