ADO datatype

In a continued effort of creating tables I've encountered another small problem. I can't seem to track down the Autonumber datatype to use in the creation of an Access table from ADO.

This just isn't working:
strSQL = "CREATE TABLE ExhibitorListNew ([ExhibitorID] short," _
& " [Exhibitor] text(50), [Order] Autonumber)"

Everything works but Autonumber. All help is ALWAYS appreciated.

Thanks in advance,
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!