472,145 Members | 1,383 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

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

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

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
0 1303

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

26 posts views Thread by David W. Fenton | last post: by
reply views Thread by Saiars | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.