I suspect that a Jet call to modify a field to identity might exist, but I have no idea what it is if it does.<BR><BR>If you're going to eventually be using SQL server, I highly suggest downloading an ...
[projectNumber] [int] IDENTITY (2000, 1) NOT NULL , [projectYear] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [description] [varchar] (255) COLLATE SQL ...