Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-12-06 : 13:12:39
|
| Simon writes "i am running an appl on access xp linked to MS SQL Server v7 (Client operating system is Windows XP/2000, Server running on Windows 2000 AS). One routine adds new records to various tables (using .addnew/.update) and updates one table several times using a pass through query. This process is done several times thru a loop. At the start of the loop, there is workspace.begintrans, followed by a workspace.committrans at the end of the loop (Should there be an error, there is a workspace.rollback). On ad-hoc occasions, the application returns odbc error 3146 (ODBC call failed). If I remove the begintrans/committrans, the error disappears. This has only started to happen when I migrated from Access 97 to Access XP.The size of the transaction log on the SQL Databases is set to expand automatically.I would appreciate any thoughts/solutions to this problem" |
|
|
|
|
|
Begintrans/commit/rollback