Is there a solution to this?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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)
  • Re: Is there a solution to this?
    ... > Lets say I have two tables, table1 and table2 that have a one to one ... > The resulting recordset can be modified but if new records are added to ... then it gives a write conflict. ...
    (microsoft.public.access.adp.sqlserver)