Re: SQL Worksheet changes not seen via ODBC?

From: Justin Cave <jocave_at_yahoo.com>
Date: 27 Aug 2002 13:26:19 -0700
Message-ID: <233b7a65.0208271226.9498403_at_posting.google.com>


davids.junk.mail_at_attbi.com (David Mueller) wrote in message news:<cb0f2869.0208270607.52625038_at_posting.google.com>...
> When I update/insert/delete data from tables using the SQL Worksheet
> (v1.3.6) I cannot see those changes via my Access 97 ODBC link -
> unless I change the structure of an index, or delete/add an index, of
> the tables involved.
>
> Facts:
> 1. Different ODBC drivers work.

Which driver(s) work and which driver(s) fail?

My guess is that the failing driver is being asked by Access to maintain a cursor for the statement "select * from <table>". If this is the case, you'd have to close the cursor (probably by closing the table in Access) and the re-open it to see the changes.

Justin Received on Tue Aug 27 2002 - 22:26:19 CEST

Original text of this message