Hello VB users,

MS Access problem.

I am still searching to create a primary key for my field in a table.
In sql there is a possibility.

Can someone complete the next code for creating a primary key for the field "NewField"?

Set Ws = DBEngine.Workspaces(0)
Set Db = Ws.CreateDatabase("c:\q.mdb", dbLangGeneral)
Dim tdfNew As TableDef

Set tdfNew = Db.CreateTableDef("newTable")

tdfNew.Fields.Append tdfNew.CreateField("NewField", dbText)

Db.TableDefs.Append tdfNew
Db.Close

Nice regards,

michelle.