Re: Is there a solution to this?

An INSTEAD OF trigger might be your solution:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_08_49kj.asp



--
Cheers,

James Goodman
"Siddharth Parekh" <skparekh@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:e%23$aAVbUFHA.3076@xxxxxxxxxxxxxxxxxxxxxxx
> Lets say I have two tables, table1 and table2 that have a one to one
> relationship
>
> Table1 has two columns - number, name
> Table2 has two columns - number, address
>
> number is the primary key and is numeric format.
>
> If i combine these two using a View having a simple SELECT statement like
> the following:
>
> SELECT table1.number, table1.name, table2.address
> FROM table1 INNER JOIN table2 ON table1.number=table2.number;
>
> This will give the output in the following format:
>
> NUMBER NAME ADDRESS
>
> The resulting recordset can be modified but if new records are added to
> this, then it gives a write conflict. The same thing in a MDB works great.
>
> Any ideas how to overcome the write conflict?
>
> Thanks,
> Sid.


.

Relevant Pages

  • Re: Is there a solution to this?
    ... > Lets say I have two tables, table1 and table2 that have a one to one ... > number is the primary key and is numeric format. ... > The resulting recordset can be modified but if new records are added to ... then it gives a write conflict. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Recordsetclone mistake
    ... > This continious form is linked with Table1 to be able to ... > Row Source is Table2. ... So the form knows about them, but its recordset ... Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.formscoding)
  • Speed of Code
    ... corresponding entries in Table2 and pull a couple of fields from Table2 into ... Table1 where those ITEMS are equal and the date is of the latest date. ... How I do this now is open table 1 as a recordset, ... When I reach the end of Table2 I use a DO LOOP to start table 1 at ...
    (microsoft.public.access.formscoding)
  • Re: About NextRecordSet
    ... Table1:= asp.NextRecordSet; ... Table2:= asp.NextRecordSet; ... > method my current recordset was changed. ... > iDummy: Integer; ...
    (borland.public.delphi.database.ado)
  • Is there a solution to this?
    ... Lets say I have two tables, table1 and table2 that have a one to one relationship ... The resulting recordset can be modified but if new records are added to this, then it gives a write conflict. ...
    (microsoft.public.access.adp.sqlserver)
Quantcast