Access odbc linked table -SQL Server

[Vince]

I have users running an Access 97 application to update records in a SQL
Server 2000 database, per an odbc linked table. After modifying a record
from within the Access application, the linked table shows the updated
record in Access; but, sometimes, the change does not propagate to the table
in SQL Server. How can that be? Exactly when does an update commit to the
SQL Server table? Thanx.

 

[Guest]

Hi Vince,

May be IMPLICIT_TRANSACTION is SET in the database.

You can run DBCC USEROPTIONS, to verify the same.

If it is on, you need to understand the implications of turning it off.