run simple SQL code from within a query

[shenhaipeng]

Guys:

An ACCESS-newbie is knocking the door ...

I am wondering whether it is possible to run a simple SQL code to add
an autonumber field from within a Make-Table query.

Right now I am doing this in two steps:

1. run the Make-Table query to create a table - tb_temp
2. write a macro with just one RunSQL action, and the SQL statement is

Alter table tb_temp ADD column ID autoincrement

It will be nice if I could do them using one step

Another related question is that the ID column is added as the last
field of the table. Is there an easy way to move it to be the first
field without doing it manully or using another make-table query?

Thanks,
Haipeng

[Bob Quintal]

sh*********@gma il.com wrote in
news:11******** *************@i 40g2000cwc.goog legroups.com:

Guys:

An ACCESS-newbie is knocking the door ...

I am wondering whether it is possible to run a simple SQL code
to add an autonumber field from within a Make-Table query.

Right now I am doing this in two steps:

1. run the Make-Table query to create a table - tb_temp
2. write a macro with just one RunSQL action, and the SQL
statement is

Alter table tb_temp ADD column ID autoincrement

It will be nice if I could do them using one step

Another related question is that the ID column is added as the
last field of the table. Is there an easy way to move it to be
the first field without doing it manully or using another
make-table query?

Thanks,
Haipeng

Just do a maketable query that puts the autonumber as the first
field.

CREATE Table tb_Tmp (PKfield autoincrement constraint PKfield
primary key, Txt1 text(25), num1 long);

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com