Create and populate an auto-increment Primary Key field with ADO

[RobJDB]

Hello,
I've created a table and populated all its fields using ADO and now I want to add an auto-increment field to it, fill it up, and make this the primary key, all within ADO. I've found bits of information on these forums but nothing comprehensive.

Also, when I'm creating fields using

With myNewTable
.Fields.Append .createfield(fname, ftype, fsize)
End With

how can I set these fields to allow zero length?

Thanks,

Rob

 

[LittleSmudge]

If you are using
myNewTable.Fields.Append .createfield(fname, ftype, fsize)

you won't need to "populate" the autonumber field - it will do that automatically - that's what the "Auto"number does for you.

 

[RobJDB]

Okay, but how do I create it with the Autonumber property and make it a primary key?

Thanks,
Rob

 

[raymondo]

Have a look at

http://www.gab2001uk.com/visualbasic/daovsado/adocreatedatabase.htm

The code you'll find there creates an entire database so within it you'll find what you're looking for.

 

[raymondo]

Raymondo again. Another site of interest for all you ADOXers out there might be

http://www.microsoft.com/data/ado/default.htm