SQL Worksheet changes not seen via ODBC?
From: David Mueller <davids.junk.mail_at_attbi.com>
Date: 27 Aug 2002 07:07:09 -0700
Message-ID: <cb0f2869.0208270607.52625038_at_posting.google.com>
[Quoted] [Quoted] 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.
Date: 27 Aug 2002 07:07:09 -0700
Message-ID: <cb0f2869.0208270607.52625038_at_posting.google.com>
[Quoted] [Quoted] 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
Received on Tue Aug 27 2002 - 16:07:09 CEST