Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Autoincremental field
0 views
Skip to first unread message
Sergey
Oct 12, 2000, 3:00:00 AM10/12/00
to
Hi ALL !
Who can advice how to create autoincremental field
in access97 table in query because if I use IDENTITY(1,1)
(as in MSSQL ADD COLUMN statement) it doesn't work.
THANK YOU IN ADVANCE
--
Best regards
Sergey
Neil Sunderland
Oct 12, 2000, 3:00:00 AM10/12/00
to
Sergey wrote:
> Who can advice how to create autoincremental field
> in access97 table in query because if I use IDENTITY(1,1)
> (as in MSSQL ADD COLUMN statement) it doesn't work.
> Who can advice how to create autoincremental field
> in access97 table in query because if I use IDENTITY(1,1)
> (as in MSSQL ADD COLUMN statement) it doesn't work.
Access has a COUNTER data type, for example:
ALTER TABLE tablename
ADD COLUMN fieldname COUNTER
Neil Sunderland
--
Barnstaple, home of the traffic jam.
If you must send me an e-mail, use neilsunderland(at)freeuk(dot)com.
Mail to the From and ReplyTo addresses are not read.
Sent via Deja.com http://www.deja.com/
Before you buy.
Sergey
Oct 12, 2000, 3:00:00 AM10/12/00
to
Thank you very much
--
Best regards
Sergey
0 new messages