Howdy, Stranger!

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

Categories

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:
[Code]
strSQL = "CREATE TABLE ExhibitorListNew ([ExhibitorID] short," _
& " [Exhibitor] text(50), [Order] Autonumber)"
[/Code]

Everything works but Autonumber. All help is ALWAYS appreciated.

Thanks in advance,
Sagacious
Sign In or Register to comment.