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,