Using SQL or Queries to define a primary key

[Jeremy]

Is there some way to use a make table query and then define the primary key,
other than going into the table and selecting it?
Thanks!

 

[Brendan Reynolds]

Public Sub TestCreateIndex()

Dim strSQL As String

strSQL = "CREATE INDEX PrimaryKey ON tblTest (TestID) WITH PRIMARY"
CurrentDb.Execute strSQL

End Sub

See the following help topic for more info ...

http://office.microsoft.com/assistance/hfws.aspx?AssetID=HP010322171033