Go Back   Access World Forums > Search Forums

 
Showing results 1 to 2 of 2
Search took 0.00 seconds.
Search: Posts Made By: dougiej
Forum: Queries 07-28-2015, 02:12 AM
Replies: 1
Views: 1,071
Posted By dougiej
Re: ODBC puzzle

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.
Forum: Queries 07-28-2015, 12:40 AM
Replies: 1
Views: 1,071
Posted By dougiej
ODBC puzzle

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,...
Showing results 1 to 2 of 2

 
Forum Jump



All times are GMT -8. The time now is 06:49 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World