• I am creating a new home page for this site, where the focus will be on directing people to the forums. If you would like to provide a testimonial, I would be most grateful. The thread where this is discussed can be found here: Seeking Testimonials Alternatively, just private message me.

ODBC puzzle (1 Viewer)

dougiej

New member
Local time
Yesterday, 21:59
Joined
Jul 28, 2015
Messages
2
I have a query which looks at a linked table (ODBC to SQL Server) in order to return a list of sub-accounts associated with an account. If I run it as a pass-through query it executes correctly, returning a list of the sub-accounts. If I run it as a query in Access it return the correct number of records but each sub account has the same name as the main account, as follows.

Result of pass through:
Main Sub
A X
A Y
A Z

Same SQL in Access:
Main Sub
A A
A A
A A
 

dougiej

New member
Local time
Yesterday, 21:59
Joined
Jul 28, 2015
Messages
2
Found it myself. The linked table is actually a view, and I had specified a unique field on the ODBC link when there is none. Not specifying any field as unique on linking removed the problem.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom