Howdy, Stranger!

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


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,


  • Justin BibJustin Bib USAMember Posts: 0

    ___ | | free video tutorials and ebooks about // R Scratch Swift MATLAB C PL/SQL Ruby Go PHP Perl Visual Basic Python C++ Visual Basic .NET Objective-C Delphi Java C# Assembly JavaScript Bash VBScript Hack Alice Scala Prolog Kotlin Erlang COBOL Clojure Transact-SQL Lisp D Logo Julia Apex Crystal FoxPro Rust Fortran LabVIEW F# Dart Lua Ada ML ABAP Awk Scheme SAS // ___________

Sign In or Register to comment.