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.
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.
Comment