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