how do I add an autonumber field in a macro?

[Snorky2k]

I haven't used Access for a couple of years. However, I need to chunk a lot
of information fast. I used to use a function in a macro something like this
but forgot what type autonumber is.

ALTER TABLE fglist ADD COLUMN id autonumber

I remember getting it to work when I got the autonumber part to work but
don't remember how I got the autonumber to work.

 

[Steve Schapel]

Snorky,

Try...
ALTER TABLE fglist ADD COLUMN id COUNTER

or...
ALTER TABLE fglist ADD COLUMN id AUTOINCREMENT