Relationship to access ( on update cascade )

Question

0.00/5 (No votes)

See more:

Hi everyone,

I'm working on a program that need to create databases and tables in a access database.
I need to create relationship and configure the On update to Cascade and same for on delete ( i've tryed the basic syntacs that works on SQL and MySQL but it dosn't work with access, apparently "update" causes syntacs problems ). So =>

First :
-Is it possible on access ?

Second :
-And if yes,how can i acheve it ?

Posted 8-Nov-11 3:57am

snoopy2011

Add a Solution

3 solutions

Solution 1

You did not mention which technology you are using but I found this

Quote:

C#

OledbConnection con = new OledbConnection("Connection String");
con.Open();

//Adding Primary Key
OledbCommand comm = new OledbCommand("alter table Table1 add constraint pk_id primary key(id)",con);
comm.ExecuteNonQuery();

//Adding Foriegn Key
comm = new OledbCommand("alter table Table2 add constraint fk_id foreign key(id) references Table1(id)",con);
comm.ExecuteNonQuery();

con.Close();

from Creating relations in MS Access with C#[^].

Posted 8-Nov-11 4:04am

André Kraak

Solution 3

Thank you very much for replying so quick, =)

But i need to create programaticaly the relation and i absolutly need the ON UPDATE and ON DELETE option to work.

The creation of the relation works but when i had "ON UPDATE" or "ON DELETE" it fails,
the error message is "syntax incorrect".

I've tryed a to configure the relation while creating the table, after creating it with "ALTER table" but still the same error message shows up =(

Can someone help me ??

Posted 8-Nov-11 6:26am

snoopy2011

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wonde Tadesse · Accepted Answer · 2011-11-08T04:06:00

Solution 2

Take a look at Cascade Updates in Microsoft Access[^] article.

Posted 8-Nov-11 4:06am

Wonde Tadesse