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.