Nethie August 24, 2010 at 11:08:47 Specs: Windows XP
I created three VIEWS using SQL 2008 and connect to them through Microsoft Access 2003 using an ODBC connection. Here is my issue. I have the results I want when I use Studio Manager and query the view on a specific record (the results have five different and unique records). However, when I open the same VIEW using Microsoft Access while I do have the right number of rows for the specific project I've queried on (five); the results are not the same but rather duplicates of one row! I'm not sure why it's doing that.
The information on Computing.Net is the opinions of its users. Such
opinions may not be accurate and they are to be used at your own risk.
Computing.Net cannot verify the validity of the statements made on this
site. Computing.Net and Purch hereby disclaim all responsibility
and liability for the content of Computing.Net and its accuracy.