By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 3,102 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

sql server 7, access97, different results when using a pass through query

P: n/a
I've got a sql server view that returns data, as a linked table to
access97 (qryPlannedPurPT)
this link table is used in an access query (qryPlannedPUR) that uses
all of the linked table fields and adds a couple of calculated fields

when I create a second query using qryPlannedPUR that adds a specific
WHERE clause
I may or may not get the correct resultset
I always get the correct number of rows, but one of the row contains
the wrong data

if I take the sql server view, which is just a query, and I create an
ms-access passthrough query and call it qryPlannedPurPT, my second
query above, always (10 out 10) returns the correct resultset

so then I went back to my linked table called qryPlannedPurPT and I
change my second query above to use it instead of qryPlannedPUR, I get
the correct resultset

so it looks like access97 sometimes has a problem using qryPlannedPUR
which is based on a link table (sql server view) qryPlannedPurPT

but it has no problems if the link-table references a sql-server
table....

has anyone seen this type of problem ?

I'm going to use the ms-access passthrough query for now, both I have
other linked-tables that reference sql server views... and it now
scares me that the result sets for those may not always be correct

Aug 28 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.