Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

How to use the IDENTITY property on an Access Table

I'm writting an ASP script that will allow me to control my Access db Files
on a web server. Is there a way to generate an autonumber field type in
Access, the same way that you do it on SQL server? For example:
CREATE TABLE new_employees
(
id_num int IDENTITY(1,1),
fname varchar (20),
minit char(1),
lname varchar(30)
)
[363 byte] By [Gaetano Siano] at [2007-11-9 15:36:03]