view result differs from the result in SQL Server

[Sandra Setz]

Hello,

I have made a view in SQL Server, that consists of a join with another
view and a table. That other view
In Access, I have linked the view as a linked table. When I view the
result there, the result is not the same as in SQL Server. The problem
is that in some cases one of the joins returns two exact the same
records in stead of two different ones.

An now, the really weird part is, that when I set the Recordsource
property of the form to a select statement from the view, the form
returns the correct records, although when I run the select statement
in the Recordsource property as a query, again the wrong results are
returned.

Is there anybody who has a clue of what can be the problem here?

Thanks in advance,
Sandra

[Reader]

Sandra,

When you link your view, make sure you correctly identify the fields
constituting uniqueness.

"Sandra Setz" <ss***@wxs.nl> wrote in message
news:74*************************@posting.google.co m...

Hello,

I have made a view in SQL Server, that consists of a join with another
view and a table. That other view
In Access, I have linked the view as a linked table. When I view the
result there, the result is not the same as in SQL Server. The problem
is that in some cases one of the joins returns two exact the same
records in stead of two different ones.

An now, the really weird part is, that when I set the Recordsource
property of the form to a select statement from the view, the form
returns the correct records, although when I run the select statement
in the Recordsource property as a query, again the wrong results are
returned.

Is there anybody who has a clue of what can be the problem here?

Thanks in advance,
Sandra

[Steve Jorgensen]

It sounds like, when linking the view, when you were asked to indicate which
fields uniquely identify a row, you gave a combination of fields that does not
completely define a unique row in the view output.

On 11 Dec 2003 04:51:42 -0800, ss***@wxs.nl (Sandra Setz) wrote:

Hello,

I have made a view in SQL Server, that consists of a join with another
view and a table. That other view
In Access, I have linked the view as a linked table. When I view the
result there, the result is not the same as in SQL Server. The problem
is that in some cases one of the joins returns two exact the same
records in stead of two different ones.

An now, the really weird part is, that when I set the Recordsource
property of the form to a select statement from the view, the form
returns the correct records, although when I run the select statement
in the Recordsource property as a query, again the wrong results are
returned.

Is there anybody who has a clue of what can be the problem here?

Thanks in advance,
Sandra