Hi
MSAccess don't understand DDL when there is multiply Create.
It understand only if I runnig one line.
ex this will create a SYNTAX ERROR at the second CREATE TABLE
CREATE TABLE Kieli (
Kieli_index Long NOT NULL,
Kieli_Nimi Text(20) NOT NULL
)
;
CREATE TABLE KunnossapitoTaso (
KuTa_index Long NOT NULL,
KuTa_Taso Text(5) NOT NULL,
KuTa_SN_Vmax Double,
KuTa_P_kN Double,
KuTa_KiskoPaino Text(10),
KuTa_Ratapölky Text(50),
KuTa_Tukikerros Text(10)
)
;
And this will work
CREATE TABLE KunnossapitoTaso (
KuTa_index Long NOT NULL,
KuTa_Taso Text(5) NOT NULL,
KuTa_SN_Vmax Double,
KuTa_P_kN Double,
KuTa_KiskoPaino Text(10),
KuTa_Ratapölky Text(50),
KuTa_Tukikerros Text(10)
)
;
