Re: SQL Worksheet changes not seen via ODBC?

[Quoted] On Tue, 27 Aug 2002 09:07:09 -0500, David Mueller wrote:

> 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.
>
> 2. When Access changes data - even local instances on different
> workstations - the changes can be seen immediately at any/all ODBC
> connections and from the SQL Worksheet.
>
> Any ideas why changes via the SQL Worksheet cannot be seen in Access97?
> Thanks,
> David

This may be a really dumb question, but after the changes you make in SQL Worksheet, do you issue a commit? You didn't mention that you did, but that's the first thing that pops into my mind.

Michael Received on Tue Aug 27 2002 - 17:30:06 CEST