Phillips
|
Posted: 04/19/2002, 7:25 AM |
|
Hello,
I have couples of table in an Access DB, there are relations between them
(one to many). Once i insert a record in Table1, i can insert many record to
Table2 and it'll link to Table1. I can go back to Update/Delete information
on Table2, however, if i go back and changes information on Table1 i got
this message "The record cannot be deleted or changed because table Table2
includes related records".
This ONLY happend if there are information on Table2 that link to Table1. If
i enter a record in Table1 and have not enter any information in Table2(link
record) then i can still go back and edit information on the Record on
Table1.
I don't want to change the relationship that i have as now, and don't
understand why that i can change the information on Table2 while can't do it
in Table1. I'm using ASP.
Thanks in advance for your comment.
|
|
|
Alexey Alexapolsky
|
Posted: 04/19/2002, 7:59 AM |
|
Did you link those tables via MS Access means ?
Or only by ids ?
--
Alex
CodeCharge Developer
"Phillips" <fdiskboy@msn.com> wrote in message
news:a9p9cr$m51$1@news.codecharge.com...
> Hello,
>
> I have couples of table in an Access DB, there are relations between them
> (one to many). Once i insert a record in Table1, i can insert many record
to
> Table2 and it'll link to Table1. I can go back to Update/Delete
information
> on Table2, however, if i go back and changes information on Table1 i got
> this message "The record cannot be deleted or changed because table Table2
> includes related records".
>
> This ONLY happend if there are information on Table2 that link to Table1.
If
> i enter a record in Table1 and have not enter any information in
Table2(link
> record) then i can still go back and edit information on the Record on
> Table1.
>
> I don't want to change the relationship that i have as now, and don't
> understand why that i can change the information on Table2 while can't do
it
> in Table1. I'm using ASP.
>
> Thanks in advance for your comment.
>
>
>
>
|
|
|
Phillips
|
Posted: 04/19/2002, 8:02 AM |
|
Thanks for your reply, Alex.
the records are links by primary key in Access.
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:a9pbcu$qj0$2@news.codecharge.com...
> Did you link those tables via MS Access means ?
> Or only by ids ?
>
> --
> Alex
> CodeCharge Developer
>
>
> "Phillips" <fdiskboy@msn.com> wrote in message
>news:a9p9cr$m51$1@news.codecharge.com...
> > Hello,
> >
> > I have couples of table in an Access DB, there are relations between
them
> > (one to many). Once i insert a record in Table1, i can insert many
record
> to
> > Table2 and it'll link to Table1. I can go back to Update/Delete
> information
> > on Table2, however, if i go back and changes information on Table1 i got
> > this message "The record cannot be deleted or changed because table
Table2
> > includes related records".
> >
> > This ONLY happend if there are information on Table2 that link to
Table1.
> If
> > i enter a record in Table1 and have not enter any information in
> Table2(link
> > record) then i can still go back and edit information on the Record on
> > Table1.
> >
> > I don't want to change the relationship that i have as now, and don't
> > understand why that i can change the information on Table2 while can't
do
> it
> > in Table1. I'm using ASP.
> >
> > Thanks in advance for your comment.
> >
> >
> >
> >
>
>
|
|
|
Geert Larsen
|
Posted: 04/20/2002, 1:50 AM |
|
Have you enabled Cascading Updates/Deletes ???
/ geert
"Phillips" <fdiskboy@msn.com> wrote in message
news:a9pbj2$r0f$1@news.codecharge.com...
> Thanks for your reply, Alex.
> the records are links by primary key in Access.
> "Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
>news:a9pbcu$qj0$2@news.codecharge.com...
> > Did you link those tables via MS Access means ?
> > Or only by ids ?
> >
> > --
> > Alex
> > CodeCharge Developer
> >
> >
> > "Phillips" <fdiskboy@msn.com> wrote in message
> >news:a9p9cr$m51$1@news.codecharge.com...
> > > Hello,
> > >
> > > I have couples of table in an Access DB, there are relations between
> them
> > > (one to many). Once i insert a record in Table1, i can insert many
> record
> > to
> > > Table2 and it'll link to Table1. I can go back to Update/Delete
> > information
> > > on Table2, however, if i go back and changes information on Table1 i
got
> > > this message "The record cannot be deleted or changed because table
> Table2
> > > includes related records".
> > >
> > > This ONLY happend if there are information on Table2 that link to
> Table1.
> > If
> > > i enter a record in Table1 and have not enter any information in
> > Table2(link
> > > record) then i can still go back and edit information on the Record on
> > > Table1.
> > >
> > > I don't want to change the relationship that i have as now, and don't
> > > understand why that i can change the information on Table2 while can't
> do
> > it
> > > in Table1. I'm using ASP.
> > >
> > > Thanks in advance for your comment.
> > >
> > >
> > >
> > >
> >
> >
>
>
|
|
|
Phillips
|
Posted: 04/22/2002, 7:00 AM |
|
Thank you all so much for your help. I found the problem of my relation in
access, i just limit down the relation and it works.
Again, thanks for all of the comments.
"Geert Larsen" <gl@fritzhansen.com> wrote in message
news:a9ra3u$933$1@news.codecharge.com...
> Have you enabled Cascading Updates/Deletes ???
>
> / geert
>
> "Phillips" <fdiskboy@msn.com> wrote in message
>news:a9pbj2$r0f$1@news.codecharge.com...
> > Thanks for your reply, Alex.
> > the records are links by primary key in Access.
> > "Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
> >news:a9pbcu$qj0$2@news.codecharge.com...
> > > Did you link those tables via MS Access means ?
> > > Or only by ids ?
> > >
> > > --
> > > Alex
> > > CodeCharge Developer
> > >
> > >
> > > "Phillips" <fdiskboy@msn.com> wrote in message
> > >news:a9p9cr$m51$1@news.codecharge.com...
> > > > Hello,
> > > >
> > > > I have couples of table in an Access DB, there are relations between
> > them
> > > > (one to many). Once i insert a record in Table1, i can insert many
> > record
> > > to
> > > > Table2 and it'll link to Table1. I can go back to Update/Delete
> > > information
> > > > on Table2, however, if i go back and changes information on Table1 i
> got
> > > > this message "The record cannot be deleted or changed because table
> > Table2
> > > > includes related records".
> > > >
> > > > This ONLY happend if there are information on Table2 that link to
> > Table1.
> > > If
> > > > i enter a record in Table1 and have not enter any information in
> > > Table2(link
> > > > record) then i can still go back and edit information on the Record
on
> > > > Table1.
> > > >
> > > > I don't want to change the relationship that i have as now, and
don't
> > > > understand why that i can change the information on Table2 while
can't
> > do
> > > it
> > > > in Table1. I'm using ASP.
> > > >
> > > > Thanks in advance for your comment.
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|