[AccessD] Alter table and alter column

Kaup, Chester A kaupca at chevrontexaco.com
Tue Dec 21 10:18:31 CST 2004


I am using the following code to change the data type of one field in a
table. Can I change more than one in a single SQL statement?
Function ChangeDataType()
    Dim cnn As ADODB.Connection
    Dim strSQL As String
    Set cnn = CurrentProject.Connection
    strSQL = "ALTER TABLE [tbl_30da] ALTER COLUMN GTM single"
    cnn.Execute strSQL
End Function

Chester Kaup
Information Management Technician
IT-MidContinent/MidContinent Business Unit
CTN 8-687-7415  
Outside 432-687-7415

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced. 






More information about the AccessD mailing list