ODBC puzzle (1 Viewer)

dougiej

New member
Local time
Today, 10:22
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
Today, 10:22
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

Top Bottom