ODBC Update

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Kam (Kam_at_discussions.microsoft.com)
Date: 02/13/05 

Date: Sun, 13 Feb 2005 15:17:05 -0800

I created a DSN for the VFP free table.

When I 1st queries the table, using SQL Pass thru it work correctly.
Then I use use under VFP environment and change the table content and
queries the tables use the SQL Pass Thru.

The table information remain the same.

I don;t know where is the problem.
But I think either the info in the free table is not updated or the queries
still look at the old info in the buffer.

Can anyone help?

Relevant Pages

  • Re: Official Status of SQLServer 2005 ADP
    ... I have said that the support for SQL passthrough ... queries under MDB was bad and worst than the one offered by ADP while you ... > attempt to "pass through" every Access query against a linked ODBC ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Massive Large Query Issues
    ... Project Budgets: Entered at the Capital Request level, ... installed (One install is typically $100,000 plus the cost of the equpment, ... install SQL Server. ... Often, a collection of queries ...
    (microsoft.public.access.queries)
  • Re: Massive Large Query Issues
    ... Project Budgets: Entered at the Capital Request level, ... install SQL Server. ... of queries? ... make of the query you provided is to roll it up into a subsequent ...
    (microsoft.public.access.queries)
  • Re: Dynamic query problem
    ... On Oct 17, 9:41 am, Andy Hull ... If we were to provide a fully featured dynamic query generator we would have ... Provided with already built queries which they can edit ... SQL and see where it is the same as for the other queries and where it ...
    (microsoft.public.access.queries)
  • Re: "Query Too Complex" Errors
    ... few dozens of queries, in the middle of which there's a long chain of ... we've been having a lot of those "Query Too ... some of the complexity in the SQL ... SQL statement you are working on. ...
    (microsoft.public.access.forms)