Add a integer column to a table with VBA 2

[vamoose]

I am using Access 2000 and trying to find the correct syntax to add an integer column named "Line" to table named "ABS_Report" Thank you for the help.

 

[jadams0173]

This should work

sql="ALTER TABLE ABS_REPORT ADD LINE INTEGER"
DOCMD.RUN SQL

I tried to have patience but it took to long! -DW

 

[Golom]

Almost

sql="ALTER TABLE ABS_REPORT ADD [red]COLUMN[/red] LINE INTEGER"
DOCMD.RUN SQL

 

[jadams0173]

I can see that would be easier to read, but I tried what I posted and it worked in Access 2k also what you posted worked and is correct way. Thanks for correcting me

I tried to have patience but it took to long! -DW

 

[vamoose]

That worked great, thanks alot. Both of you please accept a star.

Due to the nature of the database, which has alot of duplicate data, now I also need to add a second column in which will it be autonumbered so that I may step through the records one at a time. Can this be added in the same manner as before ? Thanks again.

 

[Golom]

Same idea

sql="ALTER TABLE ABS_REPORT ADD COLUMN Anum COUNTER(1,1)"
DOCMD.RUN SQL

 

[vamoose]

So, that's what I was missing, Counter(1,1). Thanks again.