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_lo ng", 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äh rung Currency NULL,
test11_währ_eur o Currency NULL,
test12_memo Memo NULL,
test13_dat_stan dard Date NULL,
test14_dat_zeit Date NULL,
test15_dat_dat Date NULL,
test16_auto_lon g Long NULL,
test17_bool_j_n Bit NULL,
test18_bool_tru e_false Bit NULL,
test19_bool_on_ off Bit NULL,
test20_ole_obje kt Binary NULL,
test21_hyperlin k 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_hyperlin k Memo NULL <-- should be a hyperlink (datatype?)
test7_dezimal Double NULL <-- should be a decimal (datatype?)
"Terry Kreft" <te*********@mp s.co.uk> wrote in message news:<bj******* ***@newsreaderm 1.core.theplane t.net>...

...
test16_auto_lon g COUNTER NULL,
...
test20_ole_obje kt LONGBINARY NULL,
...

Terry

"KePaS" <ke***@o2online .de> wrote in message
news:e8******** *************** ***@posting.goo gle.com...

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_lo ng", 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äh rung Currency NULL,
test11_währ_eur o Currency NULL,
test12_memo Memo NULL,
test13_dat_stan dard Date NULL,
test14_dat_zeit Date NULL,
test15_dat_dat Date NULL,
test16_auto_lon g Long NULL,
test17_bool_j_n Bit NULL,
test18_bool_tru e_false Bit NULL,
test19_bool_on_ off Bit NULL,
test20_ole_obje kt Binary NULL,
test21_hyperlin k 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.