ms access - assigning pk via sql query

[Bernie Yaeger]

Is there a way in MS Access to assign a PK to a table through a query. I am
creating the table with 'select .... into <tablename> from etc' which works
fine, once executed with executenonquery. But I need to give it a pk as
well - how can this be done? BTW- I'm working in vb .net, but the query I
envision would be a simple query in the .mdb itself and I would only execute
it inside vb .net.

Thanks for any help.

Bernie Yaeger

[Trevor Best]

Bernie Yaeger wrote:

Is there a way in MS Access to assign a PK to a table through a query. I am
creating the table with 'select .... into <tablename> from etc' which works
fine, once executed with executenonquery. But I need to give it a pk as
well - how can this be done? BTW- I'm working in vb .net, but the query I
envision would be a simple query in the .mdb itself and I would only execute
it inside vb .net.

Thanks for any help.

Bernie Yaeger

ALTER TABLE [TableName] ADD CONSTRAINT
[PrimaryKeyName PRIMARY KEY
(
[PrimaryKeyColumn]
)
--
But why is the Rum gone?

[Alan Webb]

Bernie,
A CREATE TABLE statement has to come first. So you probably can't do it in
one SQL statement. And Access/Jet queries don't support multiple SQL
statements in one query object so scripting this is a bit of a pain. But,
basically, create the table then use an INSERT statement to populate it.

"Bernie Yaeger" <be*****@cherwellinc.com> wrote in message
news:34*********************@news4.srv.hcvlny.cv.n et...

Is there a way in MS Access to assign a PK to a table through a query. I am creating the table with 'select .... into <tablename> from etc' which works fine, once executed with executenonquery. But I need to give it a pk as
well - how can this be done? BTW- I'm working in vb .net, but the query I
envision would be a simple query in the .mdb itself and I would only execute it inside vb .net.

Thanks for any help.

Bernie Yaeger

[Trevor Best]

Trevor Best wrote:

Bernie Yaeger wrote:

Is there a way in MS Access to assign a PK to a table through a
query. I am
creating the table with 'select .... into <tablename> from etc' which
works
fine, once executed with executenonquery. But I need to give it a pk as
well - how can this be done? BTW- I'm working in vb .net, but the
query I
envision would be a simple query in the .mdb itself and I would only
execute
it inside vb .net.

Thanks for any help.

Bernie Yaeger

ALTER TABLE [TableName] ADD CONSTRAINT
[PrimaryKeyName PRIMARY KEY
(
[PrimaryKeyColumn]
)

Sorry 'nother typo: should be "[PrimaryKeyName]" with a closing square
bracket.

--
But why is the Rum gone?