columns

[tjm77]

I want to create a column, but want to change the properties of it using code to an autonumber format? Any idea on how to do that?? this is what I have so far:


DoCmd.RunSQL ("ALTER TABLE tec_trac ADD COLUMN auto LONG;&quot

 

[RickSpr]

For LONG substitute either COUNTER or AUTOINCREMENT. Note: In your statement above, the name given the column is "auto". You probably knew that (since you keyed it in lower case) but I thought I'd mention it just in case you thought it was a keyword. Rick Sprague