Access 2007 update queries does not update table in SQL Server 200

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have this application upgraded from Access 2003. This application is front
end to SQL Server 2005. When we try to run any action queries, Access will
show command executed successfully but it will have no effect on the table in
SQL Server.

This happen when we use WorkSpace and Begin Transaction. Any updates we do
between Begin Trans to Commit trans will have no effect.

Please help

regards

Khuzema
 
Back
Top