Access odbc linked table -SQL Server

  • Thread starter Thread starter Vince
  • Start date Start date
V

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.
 
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.
 
Back
Top