Re: Pass-Through Queries

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: atrapp (atrapp_at_discussions.microsoft.com)
Date: 08/12/04 

Date: Thu, 12 Aug 2004 05:29:01 -0700

Well darned if refreshing via the Link Manager doesn't work every time! It
certainly seems to! Trouble is...it's only a fix until Access is closed. I've
also noticed that Access XP sees the correct data. I created the pass-through
query in Access 2000. I have the latest installation of MDAC ----- 2.8.

Anyone else have any ideas?

Thanks!
AT

"Alex Dybenko" wrote:

> if you are using Pass-Through Queries - there is nothing to do with linked
> tables in your DB.
> so if Pass-Through Queries returns incorrect result - could be something
> with ODBC drivers. try to install latest ADO (MDAC_TYP.exe), with also
> updates ODBC drivers, you can find it at www.microsoft.com/data
>
> --
> Alex Dybenko (MVP)
> http://Alex.Dybenko.com
> http://www.PointLtd.com
>
>
>
> "atrapp" <atrapp@discussions.microsoft.com> wrote in message
> news:67946EA0-8FD3-46E7-B65D-A4BC63AAA43A@microsoft.com...
> > Hello everyone,
> >
> > I am working with some data in Access and getting unexpected results when
> > I
> > query a table of data in SQLServer. The table has a datetime column from
> > which I would like to fetch along with data in other columns (including
> > another datetime column). The datetime column of issue shows that it is
> > NULL
> > for some records, which is fine. However, those same NULL records end up
> > having a bogus date in them when pulled via an Access query. My query type
> > of
> > choice is a pass-through query which just calls a view created in
> > SQLServer.
> > The view correctly returns NULL dates where it should when I use the
> > SQLServer tool but when using Access, the dates are bogus. I tried updated
> > the base table using the Link Manager and that seemed to work when I ran
> > the
> > query. Then, when I close out Access and go back in, I get bogus dates
> > again.
> >
> > Any suggestions are greatly appreciated and more info will be gladly
> > provided.
> >
> > Thanks,
> > --
> > AT
>
>
>

Relevant Pages

  • Re: Pass-Through Queries
    ... if you are using Pass-Through Queries - there is nothing to do with linked ... The table has a datetime column from ... > having a bogus date in them when pulled via an Access query. ...
    (microsoft.public.access.modulesdaovba)
  • Pass-Through Queries
    ... The table has a datetime column from ... having a bogus date in them when pulled via an Access query. ... choice is a pass-through query which just calls a view created in SQLServer. ... SQLServer tool but when using Access, the dates are bogus. ...
    (microsoft.public.access.modulesdaovba)
  • Pass-Through Queries/Link Manager
    ... The table has a datetime column from ... having a bogus date in them when pulled via an Access query. ... choice is a pass-through query which just calls a view created in SQLServer. ... SQLServer tool but when using Access, the dates are bogus. ...
    (microsoft.public.access.queries)
  • RE: Easy Drop Down Box Question
    ... "All States" as Bogus FROM Contacts" ... form and click on the dropdown menu a popup stating "Query input must contain ... Then in your query use something like this as the criteria for the state ... Case Else 'Multiple Selection ...
    (microsoft.public.access.forms)
  • Re: Database query performance
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... Indexing of DateTime column does not ... >> To see how the server is handling the query, you can turn on the query ... >> Please reply only to the newsgroup so that others can benefit. ...
    (microsoft.public.dotnet.framework.adonet)