[AccessD] Create Table Autonumber Field

David Emerson newsgrps at dalyn.co.nz
Tue Sep 20 23:17:18 CDT 2005


Access 97 DAO

I am creating a table using DAO.  How do I create an autonumber 
field?  My current line is:

     Set fld = tbldef.CreateField("NetExpAllowanceID", dbLong)

This of course only creates a number datatype.  I can't see in the 
help the constant for an autonumber data type.


Regards

David Emerson
Dalyn Software Ltd
999 Moonshine Rd, RD 1
Judgeford, Porirua
New Zealand 6006
Phone    0064 4 235-6782
Fax      0064 4 235-6783 




More information about the AccessD mailing list