Constraint alter table problem ( Access 2000 )

F

Filip Courtheyn

Hello,

I have a problem when I run next statement :

alter table BRIEVEN add constraint FK_BRIEVEN foreign key (PatID) references
PATIENT (PatID) on update cascade on delete cascade

It runs perfect without the on update & on delete statement. The error is
syntax error on the 'update' word.

When I run the same command to SQL 2000, no problem.

Whats the reason ?

Thanks.

Filip
 
G

Graham Mandeno

Hi Filip

It depends on which version of Jet you are using.

The KB article http://support.microsoft.com?id=180841 states:

Note: You cannot specify that you want "Cascade Updates" or "Cascade
Deletes" with a relationship created using DDL. These features are available
only when using the Microsoft DAO (Data Access Objects) interfaces via code
or when using the Microsoft Access user interface.

However, the functionality was added in Jet 4.0 (see
http://support.microsoft.com?id=275561)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add constraint returns syntax error on constrain clause 7
ON DELETE CASCADE 3
Using DDL to Create Constraint - Syntax Error 4
Referential Integrity in CREATE TABLE command 6
Adding Constraints with Cascade 1
Please Help - Syntax error in - ON UPDATE 0
Create table statement constraint syntax 3
Cascade delete 1

Top