How to create a table with an autoincrement field in an MsAccess-table with
SQL CREATE TABLE (..) ??

CREATE TABLE Customers
(
 CustId IDENTITY (1, 1) CONSTRAINT pkCustomers PRIMARY KEY,
 CFrstNm VARCHAR(10),
 CLstNm VARCHAR(15)
);

HTH
--
V. Nazarov
IT Manager, Sofia Cable

CREATE TABLE Table1 (Id COUNTER CONSTRAINT PrimaryKey PRIMARY KEY,
Text1 TEXT (10))

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com