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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
ODBC --Call Failed Error 7
Update Table 2
Access 2007 Application for Reports Only – SQL Server Security 3
Access stripping decimal places in query 1
Update Through Linked Table Timing Out 1
Subforms on main form not displaying after Access 2007 to SQL 2005 3
server rejected connection 1

Back
Top