on delete cascade problem

[hilz]

Hi all
I am trying to create a relation between two tables.

this is the sql statement in question

alter table T1
add constraint relation_T1_to_T2
foreign key (T2_ID)
references T2 (ID) on delete cascade;

This relation is created fine if i execute the SQL statement using a
connection to the database.
but if i open the datbase in MSACCESS and open the query build, switch
to the sql view, and perform it, it complains about a syntax error at
the word "delete".

does anyone know why that is?

thanks

[hilz]

hilz wrote:

Hi all
I am trying to create a relation between two tables.

this is the sql statement in question

alter table T1
add constraint relation_T1_to_T2
foreign key (T2_ID)
references T2 (ID) on delete cascade;

This relation is created fine if i execute the SQL statement using a
connection to the database.
but if i open the datbase in MSACCESS and open the query build, switch
to the sql view, and perform it, it complains about a syntax error at
the word "delete".

does anyone know why that is?

thanks

no takers?

[Trevor Best]

hilz wrote:

hilz wrote:

Hi all
I am trying to create a relation between two tables.

this is the sql statement in question

alter table T1
add constraint relation_T1_to_T2
foreign key (T2_ID)
references T2 (ID) on delete cascade;

This relation is created fine if i execute the SQL statement using a
connection to the database.
but if i open the datbase in MSACCESS and open the query build, switch
to the sql view, and perform it, it complains about a syntax error at
the word "delete".

does anyone know why that is?

thanks

no takers?

I assume the back-end database is something like SQL Server?

Access SQL is slightly different to T-SQL, if you made your query a
"pass through" one it would probably work apart from the fact you
already created the constraint so it would probably complain about that :-)

[Chris2]

"hilz" <no*@y.com> wrote in message
news:eUA8f.4995$UM1.1460@dukeread10...

hilz wrote:

Hi all
I am trying to create a relation between two tables.

this is the sql statement in question

alter table T1
add constraint relation_T1_to_T2
foreign key (T2_ID)
references T2 (ID) on delete cascade;

This relation is created fine if i execute the SQL statement using a connection to the database.
but if i open the datbase in MSACCESS and open the query build, switch to the sql view, and perform it, it complains about a syntax error at the word "delete".

does anyone know why that is?

thanks

no takers?

hilz,

You may not execute CASCADE clauses via MS Access Query Objects.

I *believe* you must use DAO and execute the SQL directly.
Sincerely,

Chris O.