Connected views deliver incorrect data!

[Tiger955]

Hi!

Front end access 2010, back end SQl-server 2008 R2.

I have all talbes and views connected to the server and due to incorrect results I found out, that the views from the server deliver incorrect data.

Of course I refreshed the views in the access front end I even deleted them and connected them for new, but the incorrect data, even a different field sequence (!) remain.
For example, in a certain field there can be two different values: 1 and 2.

If opening the view I can only see 1, on the server the view shows 1 and 2, in the records, whatever is the value.
This is not a calulated field.

When checking this in a query in access I can select on value 2 (although I cannot see it!!) and I get the correct records but in the field itself the values still show as 1 !!

Same with other values in other fields.

When I take the same SQL from the view in a stored procedure and execute is from access I get the correct data!!

On both, view and sp I have the same permissions on the server!

Any ideas why views show incorrect data??

Thanks
Michael

 

[Galaxiom]

Have a look at the design view of the Access "table" linked to the view. Sounds like it has converted the field to Boolean.

 

[Tiger955]

Thanks for the hint to have a look on the design.

Not the field type changed, but when connecting the view I defined the wrong field as Primary Key.

But what I do not understand is, that the number of records have been correct, although the wrong PK should have "filtered" the records to the half of the number.

And why a query shows the correct records with the wrong PK?

Anyhow, now it works.

Thanks
Michael