Need help with some datatypes in an Access2k-SQL-Statement

[KePaS]

I,ve got the following Script to Use on MS Access. So far it works
just fine, but I want to set "Auto-Increment" to the field
"test16_auto_long", but I don't know the expression Access wants to
have.
The same problem I have with the datatype "OLE-Object".

So here my question: how are these two datatypes called in Access-SQL?
Hope it's possible.
CREATE TABLE tblTest
(
test1_short_int Short not NULL,
test2_norm_int Integer NULL,
test3_long_int Long NULL,
test4_single Single NULL,
test5_double Double NULL,
test6_rep_ID GUID NULL,
test7_dezimal Double NULL,
test8_text_255 Text (255) NULL,
test9_währ_allg_zahl Currency NULL,
test10_währ_währung Currency NULL,
test11_währ_euro Currency NULL,
test12_memo Memo NULL,
test13_dat_standard Date NULL,
test14_dat_zeit Date NULL,
test15_dat_dat Date NULL,
test16_auto_long Long NULL,
test17_bool_j_n Bit NULL,
test18_bool_true_false Bit NULL,
test19_bool_on_off Bit NULL,
test20_ole_objekt Binary NULL,
test21_hyperlink Memo NULL
);

================================================== ========
================================================== ========

Ok, and I have just an other question. The above SQL-statement is
created out of VB. I analyze the structure of existing tables and out
of this information this SQL-string is created. But I didn't manage to
get the Primary Key out of a table via VB. How can I get this?

thx in advance.

[KePaS]

Thank you.
But I've got another question like this.

test21_hyperlink Memo NULL <-- should be a hyperlink (datatype?)
test7_dezimal Double NULL <-- should be a decimal (datatype?)
"Terry Kreft" <te*********@mps.co.uk> wrote in message news:<bj**********@newsreaderm1.core.theplanet.net >...

...
test16_auto_long COUNTER NULL,
...
test20_ole_objekt LONGBINARY NULL,
...

Terry

"KePaS" <ke***@o2online.de> wrote in message
news:e8**************************@posting.google.c om...

I,ve got the following Script to Use on MS Access. So far it works
just fine, but I want to set "Auto-Increment" to the field
"test16_auto_long", but I don't know the expression Access wants to
have.
The same problem I have with the datatype "OLE-Object".

So here my question: how are these two datatypes called in Access-SQL?
Hope it's possible.
CREATE TABLE tblTest
(
test1_short_int Short not NULL,
test2_norm_int Integer NULL,
test3_long_int Long NULL,
test4_single Single NULL,
test5_double Double NULL,
test6_rep_ID GUID NULL,
test7_dezimal Double NULL,
test8_text_255 Text (255) NULL,
test9_währ_allg_zahl Currency NULL,
test10_währ_währung Currency NULL,
test11_währ_euro Currency NULL,
test12_memo Memo NULL,
test13_dat_standard Date NULL,
test14_dat_zeit Date NULL,
test15_dat_dat Date NULL,
test16_auto_long Long NULL,
test17_bool_j_n Bit NULL,
test18_bool_true_false Bit NULL,
test19_bool_on_off Bit NULL,
test20_ole_objekt Binary NULL,
test21_hyperlink Memo NULL
);

================================================== ========
================================================== ========

Ok, and I have just an other question. The above SQL-statement is
created out of VB. I analyze the structure of existing tables and out
of this information this SQL-string is created. But I didn't manage to
get the Primary Key out of a table via VB. How can I get this?

thx in advance.