Adding a table column using VBA/ADO

[Ron Nolan]

Re: Access 2000
Does anyone know how to add column to a table using ADO?
I need to add a column called "autonum" that has a datatype of
"AutoNumber" to a table called "MyTbl".

I have searched far and wide. Books and news group threads are coming
up nill.

Thanks,
RLN

[rkc]

"Ron Nolan" <rl**********@yahoo.com> wrote in message
news:13**************************@posting.google.c om...

Re: Access 2000
Does anyone know how to add column to a table using ADO?
I need to add a column called "autonum" that has a datatype of
"AutoNumber" to a table called "MyTbl".

I have searched far and wide. Books and news group threads are coming
up nill.

Far or wide is obviously relative.

http://msdn.microsoft.com/library/de...ml/imo0143.asp

[John Winterbottom]

"Ron Nolan" <rl**********@yahoo.com> wrote in message
news:13**************************@posting.google.c om...

Re: Access 2000
Does anyone know how to add column to a table using ADO?
I need to add a column called "autonum" that has a datatype of
"AutoNumber" to a table called "MyTbl".

I have searched far and wide. Books and news group threads are coming
up nill.

sql = "alter table MyTbl add id identity(1,1) not null"
CurrentProject.Connection.Execute sql, , adExecuteNoRecords

If you want to make it the primary key, (make sure you drop any existing PK
column first)

sql = "alter table MyTbl add id identity(1,1) not null constraint PK_MyTbl
primary key"
CurrentProject.Connection.Execute sql, , adExecuteNoRecords